Re: [bug?] oddity creating table with uppercase initial

Paul Makepeace wrote:
>
> => create sequence Banks_id_seq;
> CREATE
> => CREATE TABLE "Banks" ("id" integer DEFAULT nextval('"Banks_id_seq"'::text) NOT NULL);
> CREATE
> => select * from banks;
> ERROR:  Relation "banks" does not exist

I'm new to this but I think you need to quote "Banks". Try

select * from 'Banks';

> Should I simply avoid names with uppercase? This seems like a shame.

Like the plague I should think.

It is possible to make SQL (or maybe just postgresQL) case sensitive but
I think the consensus is that it is more pain than it is worth. Someone
more versed in the in-and-outs of uppercase-lowercase issues with table
names will doubtlessly tell you all the nasty details.

HTH,

--

Jean-Christian Imbeault