Re: \dt shows table but \d says the table doesn't exist ? - Mailing list pgsql-general
From David G. Johnston
Subject Re: \dt shows table but \d says the table doesn't exist ?
Date
Msg-id CAKFQuwaL-vb93NB7cFRcLNE_uoUcYAW++r9VGbhnzqWDh4S9FQ@mail.gmail.com
Whole thread Raw
In response to Re: \dt shows table but \d says the table doesn't exist ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: \dt shows table but \d says the table doesn't exist ?
List pgsql-general
On Friday, May 3, 2024, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

Have you met people?

I really don’t care enough to try and actually make converts here.  It would have been a perfectly justifiable design choice to make our “pattern” matching case-insensitive by default, probably with a case-sensitive mode and no need to hack up quoting rules that are unique to it.  It’s a find feature and search benefits from case-insensitivity.  There isn’t anything so compelling about the current behavior that it seems like the superior choice.  But maybe you are right and I just lack sufficient real-world experience to see things differently.

I also get not wanting to change behavior at this point though I’d welcome a modifier like “*” (like the ~* operator) to enable case-insensitive matching.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: \dt shows table but \d says the table doesn't exist ?
Next
From: Tom Lane
Date:
Subject: Re: \dt shows table but \d
says the table doesn't exist ?