Re: metadata searching

From: "Juriy Goloveshkin" <j(at)gu(dot)ru>
To: "Barry Lind" <blind(at)xythos(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: metadata searching
Date: 2004-02-04 08:40:31
Message-ID: 001801c3eafa$8c2d79e0$f2c745d9@hjugonb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> You may not know this, but you can create objects with case sensitive
names:
>
> create table "Base" (columna integer);
> create table "BASE" (columna integer);
> create table Base (columna integer);
I know this. it's good if it's an sql-standard. What does it change?
>
> The first two creates will create tables whose names are case-sensitive
> and thus in order to access these tables you will always need to quote
> their names so that the SQL parser knows to retain the case. The last
> create above will create a lowercase named table as postgres folds
> unquoted identifiers to lowercase.
>
> Now the interesting thing when it comes to jdbc is that all three of the
> above tables can exist at the same time.
sql-engine can work with whis. Why jdbc code doesn't?
Did you play with your example in psql with \d <name> command? Something
different with getTable in jdbc? :) Why?

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-02-04 09:21:42 Re: Comments on adding more connection URL parameters.
Previous Message Juriy Goloveshkin 2004-02-04 08:34:48 Re: metadata searching