case insensitive table names

From: alwin <alwin(at)cs(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: case insensitive table names
Date: 2004-10-12 14:18:01
Message-ID: 6.1.2.0.0.20041012155623.025459c8@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-12 14:50:44 Re: case insensitive table names
Previous Message Tom Lane 2004-10-12 03:54:54 Re: postmaster stopps