Skip to content

Instantly share code, notes, and snippets.

@timruffles
Last active June 8, 2017 11:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timruffles/9c7bdc8916e977deb3b8fe44f1aa92ad to your computer and use it in GitHub Desktop.
Save timruffles/9c7bdc8916e977deb3b8fe44f1aa92ad to your computer and use it in GitHub Desktop.
I tried to find a limit to Posgres's table+column names. There is none! πŸ‘
scratch=# create table "delete from account;" ("""id""" text primary key, "sutff %\n" text, "&" text, "1" text, U&"\+01F600" text);
CREATE TABLE
scratch=# \d "delete from account;"
Table "public.delete from account;"
Column | Type | Modifiers
-----------+------+-----------
"id" | text | not null
sutff %\n | text |
& | text |
1 | text |
πŸ˜€ | text |
Indexes:
"delete from account;_pkey" PRIMARY KEY, btree ("""id""")
scratch=# delete from "delete from account;";
delete 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment