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
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------