Re: Table whose name has Capital letters

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Davis <jdavis@wasabimg.com>
Cc: Gabriel Fernandez <gabi@unica.edu>, pgsql-general@postgresql.org
Date: 2000-11-25T16:46:46Z
Lists: pgsql-general
Jeff Davis <jdavis@wasabimg.com> writes:
> The way it is supposed to work, everything should be
> case-insensitive. It should not matter whether you ask for nov2000 or
> Nov2000, it should be the same table, and should give you an error if
> you try to make both tables.

I am betting that he initially did CREATE TABLE "Nov2000", and is now
trying to access the table without using double quotes around its name.
Which won't work...

			regards, tom lane