Re: \dt shows table but \d says the table doesn't exist ? Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: \dt shows table but \d says the table doesn't exist ?
Дата
Msg-id CAKFQuwaL-vb93NB7cFRcLNE_uoUcYAW++r9VGbhnzqWDh4S9FQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: \dt shows table but \d says the table doesn't exist ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: \dt shows table but \d says the table doesn't exist ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: \dt shows table but \d says the table doesn't exist ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: \dt shows table but \d
says the table doesn't exist ?