Re: BUG #2648: I can not create table name with capital and

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(dot)avraham(at)gmail(dot)com>
> To: pgsql-bugs(at)postgresql(dot)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(dot)avraham(at)gmail(dot)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(at)ScienceTools(dot)com, http://ScienceTools.com/