On 18/09/2008 08:15, jisson dennis wrote: > I am using PostgreSQL 8.3.3. I am getting the following error message > ERROR: relation "project" does not exist SQL state: 42P01 > > when executing SELECT * FROM "project" But it works if the case of > tablename is changed like > > SELECT * FROM "PROJECT" > > Actually table name is PROJECT. Is there a way to completely turn off > case sensitivity of the names of table, field, sequence, etc.?
Not as far as I know. This is a function of PostgreSQL, not pgAdmin - it folds names to lower-case unless you double-quote it, hence the behaviour you observed. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgadmin-support mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
