BUG #3430: Case Sensitive Table Names

Ashwin a �crit :

The following bug has been logged online:

Bug reference: 3430
Logged by: Ashwin
Email address: ashwin_poddar@persistent.co.in
PostgreSQL version: 8.2.4
Operating system: Linux
Description: Case Sensitive Table Names
Details:

I have a strange problem,

I have created a Table with name Employee_Master
when i fire a Query as
Select * from Employee_Master
it give me an error as employee_master doesnt Exists.
but when i rename my table name as employee_master
the query works fine...
is that necessary to have table names in small case????
Please help me...

The other possibility would be to query your tables that way :

select * from "Employee_Master";

Which may not be that convenient.

Regards,
St�phane

On 7/6/07, Ashwin <ashwin_poddar@persistent.co.in> wrote:

The following bug has been logged online:

Bug reference: 3430
Logged by: Ashwin
Email address: ashwin_poddar@persistent.co.in
PostgreSQL version: 8.2.4
Operating system: Linux
Description: Case Sensitive Table Names
Details:

I have a strange problem,

I have created a Table with name Employee_Master
when i fire a Query as
Select * from Employee_Master
it give me an error as employee_master doesnt Exists.
but when i rename my table name as employee_master
the query works fine...
is that necessary to have table names in small case????

Only if you have quoted the table names while creating them.

For eg, The following two commands will create tables with different names:

create table "Test"( a int );

create table "test"( a int );

create table "TesT"( a int );

Postgres converts all identifiers to lower-case, unless they are quoted.

HTH

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

17°29'34.37"N 78°30'59.76"E - Hyderabad
18°32'57.25"N 73°56'25.42"E - Pune *

Mail sent from my BlackLaptop device