Case sensitivity

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

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.

Thank you ALL.

On Tue, Dec 23, 2025 at 4:23 PM David G. Johnston
<david.g.johnston@gmail.com> wrote: