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

SQL is case insensitive, except for the actual data.
Most commercial databases deal with this by forcing
everything to upper case (the SQL standard appears to
support this approach); PostgreSQL forces everything
to lower case. This was a choice made long ago, and
nobody is in a hurry to change it. Either way, you
will have a problem.

The answer is to double quote your mixed case
identifiers: select * from "Banks";

The name must have been quoted when the table was
created; if you are unaware of that, you must have
used some administration/migration tool that quoted
the names without your knowing.

Since you must remember to quote the names every time
you use them, mixed case names are a trap waiting to
spring. My experience is that they are more trouble
than they are worth.

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com