Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name - Mailing list pgsql-bugs

From Milen A. Radev
Subject Re: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name
Date
Msg-id fn795b$7mv$1@ger.gmane.org
Whole thread Raw
In response to Re: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name  (Adam Hardy <adam.hardy@cyberspaceroad.com>)
List pgsql-bugs
Tree view 
Adam Hardy написа:
[...]
> it seems to me from what you just said that PostgreSQL server and JDBC
> driver require the schema name to be lower case deliberately, and that
> any given name that is not all lower case is converted to lower case by
> the server or the driver. Am I correct?


http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS,
(especially the last paragraph of 4.1.1.),



--
Milen A. Radev

pgsql-bugs by date:

Previous
From: "Dave Page"
Date:
Subject: Re: BUG #3895: Access denied
Next
From: "Harald Armin Massa"
Date:
Subject: Re: 8.2 and 8.3 postgresql.conf oddity