Re: BUG #19043: jdbc connection url is not case insensitive

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: m.kristo@rewe-group.at, pgsql-bugs@lists.postgresql.org
Date: 2025-09-06T00:41:43Z
Lists: pgsql-bugs
An alternate view: if you really care about case, double quote the database
on creation, as per your "e.g.":

create database "testDB";

At that point, your psql connection will work. But as with all
non-lowercase objects, extra care will be needed and it will need to be
quoted in some contexts. It's so much easier to just leave database,
schema, table, and column names as lowercase. Then everything just works.

Cheers,
Greg