Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE - Mailing list pgsql-general

From Karsten Hilbert
Subject Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE
Date
Msg-id trinity-707e4654-ba60-489d-8e0d-bae8ff01bc3e-1665047790410@3c-app-gmx-bap26
Whole thread Raw
In response to Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE
List 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
resulstdisplay, 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
 



pgsql-general by date:

Previous
From: Gavan Schneider
Date:
Subject: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE
Next
From: Wen Yi
Date:
Subject: [Beginner Question]How to generate a call-graph for project?