Обсуждение: Case sensitivity

Поиск
Список
Период
Сортировка

Case sensitivity

От
Igor Korot
Дата:
Hi, ALL,
In the https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS,
there is no indication whether those values are case sensitive or not.

Thank you,



Re: Case sensitivity

От
Adrian Klaver
Дата:
On 12/23/25 14:08, Igor Korot wrote:
> Hi, ALL,
> In the https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS,
> there is no indication whether those values are case sensitive or not.

Easy enough to test:

psql postgresql://aklaver@localhost/test

Null display is "NULL".
psql (18.1 (Ubuntu 18.1-1.pgdg22.04+2), server 17.7 (Ubuntu 
17.7-3.pgdg22.04+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, 
compression: off, ALPN: postgresql)
Type "help" for help.

test=>


VS

psql postgresql://aklaver@localhost/TEST

psql: error: connection to server at "localhost" (127.0.0.1), port 5432 
failed: FATAL:  database "TEST" does not exist
> 
> Thank you,
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



Re: Case sensitivity

От
"David G. Johnston"
Дата:
On Tue, Dec 23, 2025 at 3:08 PM Igor Korot <ikorot01@gmail.com> wrote:
Hi, ALL,
In the https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS,
there is no indication whether those values are case sensitive or not.


One should assume case-sensitivity unless otherwise stated.

David J.
 

Re: Case sensitivity

От
Igor Korot
Дата:
Thank you ALL.

On Tue, Dec 23, 2025 at 4:23 PM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Tue, Dec 23, 2025 at 3:08 PM Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Hi, ALL,
>> In the https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS,
>> there is no indication whether those values are case sensitive or not.
>>
>
> One should assume case-sensitivity unless otherwise stated.
>
> David J.
>