Asaf, quote them and it will work.
Richard On Sun, 24 Sep 2006, Asaf Avraham wrote: > Date: Sun, 24 Sep 2006 06:18:38 GMT > From: Asaf Avraham <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #2648: I can not create table name with capital and > small characters > > > The following bug has been logged online: > > Bug reference: 2648 > Logged by: Asaf Avraham > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4.2 > Operating system: win > Description: I can not create table name with capital and small > characters > Details: > > I have table that contain name with capital and small characters (ex. > tblEmp). In the columns is the same (ex. EmpID). > > In Creating table postgres add inverted commas on the name > > When I'm running any query on this table i get: > 1. select * from tblEmp > Get: ERROR: relation "tblemp" does not exist > 2. select * from "tblEmp" > Get: Resulted > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
