Message-ID: <3DB93607.2050202@wettzell.ifag.de>
Date: Fri, 25 Oct 2002 14:16:07 +0200
From: Reiner Dassing <dassing@wettzell.ifag.de>
Organization: BKG-Wettzell
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE;
	rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Upper / lower cases on table and column names
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit

(PostgreSQL) 7.1.1:

Hello all!

I was trying to adopt a database application to PostgreSQL.
(It is written for MySQL and Oracle using perl)

During this process I recognized the phenomena that upper case letters
of table names and column names are not preserved
in PostgreSQL.
Is this a "featue" of PostgreSQL or do I miss something?

Example:
Id and textId as a column name should conserve upper case letters 'I'
but \d data converts it to lower case words:

psql ...
create table data ( Id int not null, textId int not null);

\d data
           Table "data"
  Attribute |  Type   | Modifier
-----------+---------+----------
  id        | integer | not null
  textid    | integer | not null

and
create table Data ( Id int not null, textId int not null);

results in:
ERROR:  Relation 'data' already exists

In the interpretation of my application table 'data' and 'Data' is something 
different.

-- 
--
Mit freundlichen Gruessen / With best regards
    Reiner Dassing