From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | Bryn Llewellyn <bryn(at)yugabyte(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE |
Date: | 2022-10-06 09:16:30 |
Message-ID: | trinity-707e4654-ba60-489d-8e0d-bae8ff01bc3e-1665047790410@3c-app-gmx-bap26 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What we deal with in our ordinary professional work is SQL texts, program source texts, within these, SQL identifier texts, and then the conventional display of the results of SQL and program execution. To emphasize the point about resulst display, try "\d s.*" in "\t off" mode. You'll see this:
Table "s.silly name"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
n | integer | | |
But this SQL text:
drop table "s.silly name";
tells me that there's no such table.
And, indeed, there isn't. Perhaps there's a table s."silly name".
It is accidental if unfortunate that the <s.silly name> is quoted with ""'s in the \d output...
Karsten
From | Date | Subject | |
---|---|---|---|
Next Message | Wen Yi | 2022-10-06 12:16:52 | [Beginner Question]How to generate a call-graph for project? |
Previous Message | Gavan Schneider | 2022-10-06 08:49:58 | Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE |