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

Re: Turning of case sensitivity for identifiers?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Turning of case sensitivity for identifiers?
Date: 2004-07-14 09:37:19
Message-ID: 200407141137.19713.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Am Mittwoch, 14. Juli 2004 10:55 schrieb Joost Kraaijeveld:
> Is it possible to turn of the case sensitivity for tables and columns in
> queries (to all CAPS)?  I have a (closed source) tool that I have to use
> (Clarion) that generates the queries and I cannot change the way the tool
> generates the queries.

The table and column names are not actually case sensitive; they are just 
folded to lower case while you apparently expect upper case.  If you write 
the names the same way in each command, there should not be a problem.  What 
problem are you actually seeing?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

pgsql-admin by date

Next:From: Joost KraaijeveldDate: 2004-07-14 09:53:39
Subject: Re: Turning of case sensitivity for identifiers?
Previous:From: Joost KraaijeveldDate: 2004-07-14 08:55:05
Subject: Turning of case sensitivity for identifiers?

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