Re: 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(at)persistent(dot)co(dot)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