Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] problem with DatabaseMetaData and mixed case

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [PATCH] problem with DatabaseMetaData and mixed case
Date: 2005-08-08 23:53:46
Message-ID: 1123545227.9087.1.camel@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Il giorno lun, 08/08/2005 alle 16.55 -0500, Kris Jurka ha scritto:
> Postgresql folds identifiers to lowercase as long as they are created
> without quotes.  Using CREATE TABLE "MyTable" (...) will indeed retain the
> case of MyTable.  We do not fold DatabaseMetaData parameters to lowercase
> because that would prevent you from retrieving data from a table created
> as "MyTable".  The DatabaseMetaData methods like
> storesLowerCaseIdentifiers() helps allow portable code to call the other
> methods with the correct name.  It doesn't help you if you don't know if 
> the table name was originally created as MyTable or "MyTable", but if 
> that's the case a call to getTables may be in order.
> Kris Jurka

Thank you, and to Oliver Jowett, for this explaination.


In response to

pgsql-jdbc by date

Next:From: Barry LindDate: 2005-08-09 17:19:20
Subject: Is anyone aware that the 8.1dev download links on the website are broken?
Previous:From: Oliver JowettDate: 2005-08-08 22:07:17
Subject: Re: [PATCH] problem with DatabaseMetaData and mixed case table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group