Duplicate Table Names in PostgreSQL
От | Schnetzer, Jerry |
---|---|
Тема | Duplicate Table Names in PostgreSQL |
Дата | |
Msg-id | 983512280A017A4A9FCF805FDC902A1F454476@nextnet01.nextnetwireless.com обсуждение исходный текст |
Список | pgsql-odbc |
I have just started to use PostgreSQL. Among creating sql scripts to create my database and schema, I also need to exportexisting data from a MS SQL database. This has worked well using the postgreSQL ODBC driver in conjunction with MSData Transformation Services (DTS) to export and move the data to PostgreSQL running on Linux. My question is this. When I run my create database scripts using psql, it converts all of my mixed table and column namesinto lower case; even though I have specified mixed names in the SQL script file. However, when I run DTS and exportthe data into the Postgres database (uses PostgreSQL ODBC), this process does in fact create a mixed table name inaddition to the lower case version of the same table. Using psql, I can display the tables information (\dt) and see a display of both the lower and mixed case table. However, when I drop a table (specifying either a mixed or lower case name), PostgreSQL seems to only have one instance ofthe table. After dropping, a select statement against the table, is reported by psql, as not existing. How is this happening? Jerry Schnetzer Minneapolis
В списке pgsql-odbc по дате отправления: