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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: m(dot)kristo(at)rewe-group(dot)at, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19043: jdbc connection url is not case insensitive
Date: 2025-09-06 00:41:43
Message-ID: CAKAnmm+_VdCjJgiGra5PYXB1gox-NEMaiajJdB=fdhXfFBmM1w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Álvaro Herrera 2025-09-06 08:42:25 Re: Broken PQtrace CopyData display
Previous Message Tom Lane 2025-09-05 21:20:06 Re: BUG #19043: jdbc connection url is not case insensitive