Re: \dt shows table but \d says the table doesn't exist ? Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: \dt shows table but \d says the table doesn't exist ?
Дата
Msg-id CAMsGm5c8LG4vQ9SY4J5Hjco9XEqJUGcNtK+sR=TGFDGHnv5cTw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: \dt shows table but \d says the table doesn't exist ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: \dt shows table but \d says the table doesn't exist ?
Следующее
От: AJ ONeal
Дата:
Сообщение: How to Build Postgres in a Portable / Relocatable fashion?