Guest User

Untitled

a guest
Feb 16th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. create table "TEST" ("Col1" bigint);
  2.  
  3. select table_schema, table_name from information_schema.tables where not table_schema='pg_catalog' and not table_schema='information_schema';
  4.  
  5. TEST = test <-- non case sensitive
  6. "Test" <> Test <-- first is precise, second one is turned to lower case
  7. "Test" = "Test" <-- will work
  8. "test" = TEST <-- should work; but you are just lucky.
  9.  
  10. select
  11. quote_ident(table_schema) as table_schema,
  12. quote_ident(table_name) as table_name
  13. ...
  14.  
  15. table_schema | table_name
  16. --------------+------------------
  17. ...
  18. public | good_name
  19. public | "table"
  20. public | some_table
  21. public | "something else"
  22. public | "Tom's work"
  23. public | "TEST"
  24. ...
Add Comment
Please, Sign In to add comment