Hello,
thanks for the answers and you are absolutely right.
I think then we can close this issue.
Best Regards
Marijo
Von: Greg Sabino Mullane <htamfids@gmail.com>
Gesendet: Samstag, 6. September 2025 02:41
An: Kristo Marijo <m.kristo@rewe-group.at>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Betreff: Re: BUG #19043: jdbc connection url is not case insensitive
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. If you are unsure or already opened a link or attachment please contact your local IT helpdesk.
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
