Re: Table whose name has Capital letters - Mailing list pgsql-general

From Tom Lane
Subject Re: Table whose name has Capital letters
Date
Msg-id 659.975170806@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table whose name has Capital letters  (Jeff Davis <jdavis@wasabimg.com>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sql-bench
Next
From: "Joel Burton"
Date:
Subject: Warning: Don't delete those /tmp/.PGSQL.* files