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

> >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

>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

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

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.getPrimaryKeys(), i

[GENERAL] where to find dbf2pg-3.0?

should be simple, but it seems to have disappeared from the locations dredged up by altavista et al. anybody have a copy lying around? thanks jeff

[GENERAL] pg_dump

Hello everybody, I would be really happy to find out why pg_dump doesn't work on my site. Whatever I do the result is: -- last builtin oid is 17184 -- reading user-defined types -- reading user-defined functions -- reading user-defined aggregates -- reading user-defined operators --

[ADMIN] How to use text type field....

Hi~ Everyone... I have some problem... with PostgreSql Version 6.4 I don't know how to use text type data filed... Hm... --- create table test( id int primary key, data1 text) How to use "insert into test" ?? How