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: (view raw or whole thread)
Lists: pgsql-odbc
--- Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>

> 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

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

Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 

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-2015 The PostgreSQL Global Development Group