Re: pg_type name quotability - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: pg_type name quotability
Date
Msg-id CADK3HHJAcqRsR5KZ5BTxE3uwpE6quiauNkfWTFPEQ8X6O_LwJQ@mail.gmail.com
Whole thread Raw
In response to pg_type name quotability  (Kevin Wooten <kdubb@me.com>)
List pgsql-jdbc
Hi Kevin,

No, but let me know when you figure it out!

Quoting identifiers in postgres has always been problematic. PgAdmin takes the position that everything gets quoted, regardless which has it's own issues


On 2 December 2015 at 05:21, Kevin Wooten <kdubb@me.com> wrote:
Does anybody know if the name of a type/table in these system tables is guaranteed to be in a quotable format?  Ran into a specific instance where the table name needs to be quoted by the driver (e.g. “user”) but want to make sure it’s always valid to quote the name from pg_type.

Thanks!

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Migration to Maven
Next
From: Tom Lane
Date:
Subject: Re: pg_type name quotability