From: alwin <alwin@cs.nl>
To: pgsql-admin@postgresql.org
Subject: case insensitive table names
Date: Tue, 12 Oct 2004 16:18:01 +0200
Message-ID: <6.1.2.0.0.20041012155623.025459c8@localhost> (raw)
Dear mailing list,
I'm trying to convert a MsSQL database to a Postgres database, with DTS i can
convert the data between the databases. DTS creates case sensitive tables
(using quotes), exactly like i want it to be.
So far so good. But the current code uses queries without quotes, like
select * from Table; and not select * from "Table";. The Table gets
converted to
lowercase and then compared (case sensitive) against the tables in the
database.
This means i have to convert all the table names to lowercase, losing a lot
of readability,
or i put quotes around all the table names in the current queries causing
also a lot of
possible problems and unneeded changes.
Is there an easier fix for this? Does the SQL92/SQL3/SQL2003 specify
unquoted table
names to be case-insensitive or does it say it needs to be converted to
lowercase?
It would be great having a global flag to enable or disable case sensitive
compares
everywhere.
Thanks.
Alwin
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-admin@postgresql.org
Cc: alwin@cs.nl
Subject: Re: case insensitive table names
In-Reply-To: <6.1.2.0.0.20041012155623.025459c8@localhost>
* 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