Re: Turn Off Case Sensitive

[Raymond O'Donnell <rod(at)iol(dot)ie>]

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------