Re: Windows, ODBC drivers and strange points ...

From: Christian Schröder <cs(at)deriva(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Windows, ODBC drivers and strange points ...
Date: 2005-10-10 11:46:33
Message-ID: 434A5499.3010001@deriva.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Marten Feldtmann wrote:

> This means, that under PostgreSQL one should in general quote
> the column names when creating them ? Do I also have to quote
> them in the SELECT statements ???

Exactly. However, this is a database issue, not a driver issue. Quoting
http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS:

> Identifier and key word names are case insensitive. Therefore
>
>UPDATE MY_TABLE SET A = 5;
>
> can equivalently be written as
>
>uPDaTE my_TabLE SeT a = 5;
>
>[...]
>
>Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case. For example, the identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are different from these three and each other.
>

Regards
Christian

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2005-10-10 12:32:23 Re: Windows, ODBC drivers and strange points ...
Previous Message Cleber Nardelli 2005-10-10 11:42:55 Problem with psqlODBC on "Cache Size"