Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

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
 

In response to

Responses

Browse pgsql-general by date

  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