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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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