Re: [GENERAL] Re: Bug#108286: case sensitivity in column names - Mailing list pgsql-odbc

From Tom Lane
Subject Re: [GENERAL] Re: Bug#108286: case sensitivity in column names
Date
Msg-id 11812.997451293@sss.pgh.pa.us
Whole thread Raw
List pgsql-odbc
"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

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC 7.1
Next
From: Ketil Malde
Date:
Subject: Re: Bug#108286: case sensitivity in column names