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