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

Re: Table and Column name folding question

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>,"Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Table and Column name folding question
Date: 2005-01-18 14:59:22
Message-ID: 20050118145922.31067.qmail@web20823.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
wrote:

> 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)?

Correct.  PostgreSQL will look for an exact match,
where quoted identifier (table, column etc.) names are
used.

There is a great deal of discussion of this question
in the list archives (try the pgsql-general list).

> 
> 
> 
> 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 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 



		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 


In response to

pgsql-odbc by date

Next:From: Együd CsabaDate: 2005-01-18 20:49:23
Subject: psqlodbc 08.00.0004 - questions
Previous:From: Joost KraaijeveldDate: 2005-01-18 09:19:52
Subject: Table and Column name folding question

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