Обсуждение: Turn Off Case Sensitive

Hi,
 
     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.?




--
Be Yourself @ mail.com!
Choose From 200+ Email Addresses
Get a Free Account at www.mail.com

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