Re: \dt shows table but \d says the table doesn't exist ? - Mailing list pgsql-general
From Isaac Morland
Subject Re: \dt shows table but \d says the table doesn't exist ?
Date
Msg-id CAMsGm5c8LG4vQ9SY4J5Hjco9XEqJUGcNtK+sR=TGFDGHnv5cTw@mail.gmail.com
Whole thread Raw
In response to Re: \dt shows table but \d says the table doesn't exist ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, 3 May 2024 at 17:28, Tom Lane <tgl@sss.pgh.pa.us> wrote:

This is one of the places where it's unfortunate that our English-text
rule for quoting a string to set it off from the rest of the error
message collides with SQL's rule for quoting an identifier.  Leaving
out the outer quotes would be contrary to our style guide, but having
them there can be confusing too to people who know SQL well.

I'm not sure if this is a serious suggestion or not: enclose the name of the table, as you would type it in psql, between curly quotes.

So for example:

“table_name”
“"TableNameWithUpperCaseLetters"”

In a context where the curly quotes and surrounding message could be in a non-monospaced typeface and the table name (including double quote marks if needed) in a monospaced typeface this would be more natural.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: \dt shows table but \d says the table doesn't exist ?
Next
From: AJ ONeal
Date:
Subject: How to Build Postgres in a Portable / Relocatable fashion?