Re: BUG #2764: Capital letter in tables or columns not supported - Mailing list pgsql-bugs

On 11/17/06, Ron Teitelbaum <ron@usmedrec.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2764
> Logged by:          Ron Teitelbaum
> Email address:      ron@usmedrec.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