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

Table and Column name folding question

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject: Table and Column name folding question
Date: 2005-01-18 09:19:52
Message-ID: A3D1526C98B7C1409A687E0943EAC41001EB34@obelix.askesis.nl (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

I have a Clarion generated application that uses both quoted and unquoted table and column names. It is not consistant in the use of quotes: the same table sometimes is used with and sometimes without quotes. When used with quotes, the name of the table/column is always uppercase. Without quotes it is in lowercase.

The PostgreSQL docs say that unquoted names are folded to lower case. 

But does that also mean that quoted upper case table and column names cannot be used to access a table or column that is created without quotes (lower case)?



Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl 

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2005-01-18 14:59:22
Subject: Re: Table and Column name folding question
Previous:From: Claudio DuffiniDate: 2005-01-17 18:16:18
Subject: Re: ODBC release plans?

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