Re: BUG #3430: Case Sensitive Table Names - Mailing list pgsql-bugs

From Stéphane Schildknecht
Subject Re: BUG #3430: Case Sensitive Table Names
Date
Msg-id 468DF184.1080508@postgresqlfr.org
Whole thread Raw
In response to BUG #3430: Case Sensitive Table Names  ("Ashwin" <ashwin_poddar@persistent.co.in>)
List pgsql-bugs
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




pgsql-bugs by date:

Previous
From: balajisundar@midascomm.com
Date:
Subject: DB Install Problem
Next
From: "Gurjeet Singh"
Date:
Subject: Re: BUG #3430: Case Sensitive Table Names