Re: BUG #19043: jdbc connection url is not case insensitive - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: BUG #19043: jdbc connection url is not case insensitive
Date
Msg-id CAKAnmm+_VdCjJgiGra5PYXB1gox-NEMaiajJdB=fdhXfFBmM1w@mail.gmail.com
Whole thread Raw
In response to BUG #19043: jdbc connection url is not case insensitive  (PG Bug reporting form <noreply@postgresql.org>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19043: jdbc connection url is not case insensitive
Next
From: Álvaro Herrera
Date:
Subject: Re: Broken PQtrace CopyData display