Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

> Identifier and key word names are case insensitive. Therefore
> 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.


In response to

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group