Turn Off Case Sensitive

From: "jisson dennis" <jissondennis(at)yours(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Turn Off Case Sensitive
Date: 2008-09-18 07:15:19
Message-ID: 20080918071519.8CFB547808F@ws1-5.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2008-09-18 08:22:30 Re: Turn Off Case Sensitive
Previous Message Craig Ringer 2008-09-15 04:32:06 Re: [GENERAL] PostgreSQL