Thread: Re: [GENERAL] Re: Bug#108286: case sensitivity in column names

Re: [GENERAL] Re: Bug#108286: case sensitivity in column names

From
Tom Lane
Date:
"Oliver Elphick" <olly@lfix.co.uk> writes:
> Ketil Malde wrote:
>>>> Notice how it uses mixed case column names here?

> And therefore should have double-quoted them.

Or not double-quoted them --- but it has to be consistent about it.
"FooBar" and FooBar are not the same name according to the SQL standard.
So if you quote column names in the CREATE TABLE command, you have to
quote 'em forevermore.  And if not, not.

            regards, tom lane