case insensitive table names
От | alwin |
---|---|
Тема | case insensitive table names |
Дата | |
Msg-id | 6.1.2.0.0.20041012155623.025459c8@localhost обсуждение исходный текст |
Ответы |
Re: case insensitive table names
|
Список | 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
В списке pgsql-admin по дате отправления: