SHARE
TWEET

Untitled

a guest Feb 16th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.  ...
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top