Re: Case sensitivity

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Case sensitivity
Date: 2025-12-23 22:23:29
Message-ID: 32f35529-ea7c-410a-a4f8-05eb9db698c6@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-12-24 00:23:11 Re: Case sensitivity
Previous Message Igor Korot 2025-12-23 22:08:20 Case sensitivity