From: Reiner Dassing <dassing@wettzell.ifag.de>
To: pgsql-sql@postgresql.org
Subject: Upper / lower cases on table and column names
Date: Fri, 25 Oct 2002 14:16:07 +0200
Message-ID: <3DB93607.2050202@wettzell.ifag.de> (raw)
(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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dassing@wettzell.ifag.de
Subject: Re: Upper / lower cases on table and column names
In-Reply-To: <3DB93607.2050202@wettzell.ifag.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox