Re: \dt shows table but \d <table> says the table doesn't exist ?

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Isaac Morland <[email protected]>
To: Tom Lane <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: David Gauthier <[email protected]>
Cc: [email protected]
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: Fri, 3 May 2024 18:08:25 -0400
Message-ID: <CAMsGm5c8LG4vQ9SY4J5Hjco9XEqJUGcNtK+sR=TGFDGHnv5cTw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
	<CABUevEwkSS_FhL0Zi1_m3oU5WqELHF+qQfCLDK3e__qTsYdsYw@mail.gmail.com>
	<[email protected]>
	<CABUevEyf0skbu3scVQ28_d69CCr8Bp+tU3x1AazsFwWhFJ8x8Q@mail.gmail.com>
	<[email protected]>

On Fri, 3 May 2024 at 17:28, Tom Lane <[email protected]> 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.

view thread (17+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
  In-Reply-To: <CAMsGm5c8LG4vQ9SY4J5Hjco9XEqJUGcNtK+sR=TGFDGHnv5cTw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox