| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | David Raymond <David(dot)Raymond(at)tomtom(dot)com> |
| Cc: | "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org> |
| Subject: | Re: Creating dynamically-typed tables using psycopg2's built-in formatting |
| Date: | 2019-06-13 20:35:15 |
| Message-ID: | 628DF67F-7CFE-48DD-B01D-D7D7C9B53894@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
> On Jun 13, 2019, at 13:29, David Raymond <David(dot)Raymond(at)tomtom(dot)com> wrote:
> For the capitalization thing basically what's going on is two things. (The way I understand it)
> 1) Postgres IS case sensitive.
> 2) When any query gets sent to the server, the server converts everything not inside quotes to lower case as step 1, _before_ trying to match names for tables, columns, functions, etc.
It's a bit more elaborate than that, although that's not a bad summary of the perceived result. The details are here:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS\
--
-- Christophe Pettus
xof(at)thebuild(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Cohen | 2019-06-13 20:54:53 | Re: Creating dynamically-typed tables using psycopg2's built-in formatting |
| Previous Message | David Raymond | 2019-06-13 20:29:04 | RE: Creating dynamically-typed tables using psycopg2's built-in formatting |