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.


I get a simular problem with capital letters in column names. The error is
column not defined.

The table was created manually using PGAdmin.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On 11/17/06, Ron Teitelbaum <ron (AT) usmedrec (DOT) com> wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster