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 <asaf.avraham@gmail.com>
> 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: asaf.avraham@gmail.com
> 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
rtroy@ScienceTools.com, http://ScienceTools.com/