RE: [GENERAL] problem of upper/lower case in table names

1998-11-18 Thread Postgres DBA
On Tue, 17 Nov 1998, Taral wrote: > > >i've got this annoying problem : if you create a table with an uppercase > > >name, postgres transforms it in lower case. After that, if you try to > > >retrieve the primary keys for this table ( still using the uppercase > > >name as argument ) using the

RE: [GENERAL] problem of upper/lower case in table names

1998-11-17 Thread Taral
> >i've got this annoying problem : if you create a table with an uppercase > >name, postgres transforms it in lower case. After that, if you try to > >retrieve the primary keys for this table ( still using the uppercase > >name as argument ) using the JDBC driver > >DatabaseMetaData.getPrimaryKey

Re: [GENERAL] problem of upper/lower case in table names

1998-11-17 Thread Jay O'Connor
>Hi all, > >i've got this annoying problem : if you create a table with an uppercase >name, postgres transforms it in lower case. After that, if you try to >retrieve the primary keys for this table ( still using the uppercase >name as argument ) using the JDBC driver >DatabaseMetaData.getPrimaryKe