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