Re: BUG #2764: Capital letter in tables or columns not supported

On 11/17/06, Ron Teitelbaum <ron(at)usmedrec(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2764
> Logged by: Ron Teitelbaum
> Email address: ron(at)usmedrec(dot)com
> PostgreSQL version: 1.4.1
> Operating system: Windows
> Description: Capital letter in tables or columns not supported
> Details:
>
> I ran into a very weird problem that tured out to be a capital letter in the
> table name or column name. When trying to query a table with a capital
> letter in the name I get error relation not defined.
>
> I can get it to work with something like:
> select * from "zipCodes"
>
> It appears to be completely case insensitive if the table is all lowercase.
>
>

that's not a bug... if you create a table or column with capital
letters postgres transform it to lowercase...

if you don't want that you need to double quotes...

create table "Foo" (Col1 int);
select * from "Foo";

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook