From: | Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org> |
---|---|
To: | Ashwin <ashwin_poddar(at)persistent(dot)co(dot)in> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3430: Case Sensitive Table Names |
Date: | 2007-07-06 07:38:44 |
Message-ID: | 468DF184.1080508@postgresqlfr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Pelle Johansson | 2007-07-06 08:44:08 | BUG #3431: age() gets the days wrong |
Previous Message | Ashwin | 2007-07-06 07:08:57 | BUG #3430: Case Sensitive Table Names |