Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group