public inbox for [email protected]  

help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Tom Lane <[email protected]>
Cc: jian he <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: David Gauthier <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: Fri, 3 May 2024 21:06:20 -0700
Message-ID: <CAKFQuwbLcGQHw+catBy65FyKsD6zm9z2=94RecqYSVcyBverwg@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]>
	<[email protected]>
	<CACJufxF=VJ=wprULGXLuAaSt5j+4w0=66HzKDQ9GEKFXMo1-bg@mail.gmail.com>
	<[email protected]>

On Friday, May 3, 2024, Tom Lane <[email protected]> wrote:
>
>
> By and large, I'd expect people using mixed-case table names to get
> accustomed pretty quickly to the fact that they have to double-quote
> those names in SQL.  I don't see why it's a surprise that that is also
> true in \d commands.
>
>
Every day the number of people increases who get mixed-case names in their
DB because their client language preserves case and doesn’t require quoting.

And it isn’t like any sane person is using case to distinguish names in
their DB and so would be at risk of seeing multiple unwanted matches for
any given pattern.

I don’t think name pattern matching during object lookup is a good tool to
wield to try and convince people that using camel case is a bad idea and
they should use snake case instead.  If they don’t write enough raw SQL to
be annoyed by their choice more power to them, making \d more accessible
for them is a win and snake case people won’t notice or care.

David J.


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], [email protected]
  Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
  In-Reply-To: <CAKFQuwbLcGQHw+catBy65FyKsD6zm9z2=94RecqYSVcyBverwg@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