Just searched the archives but no match for this problem that I can see:
Exporting an MS SQL 2000 table to PostgreSQL 7.1.3 fails due to uppercase
table names.
MS SQL is set to quote all identifiers so the queries are sent in the format:
'create table TEST(ABC int)'
However, when MS SQL sends a query 'select * from test', the ODBC fails with
"ERROR: Relation 'test' does not exist" as it is looking for the lowercase
version of the table.
Through psql, the uppercase table names are converted into lowercase so
PostgreSQL seems to be okay. Is this a problem with the ODBC driver?
If so, are there any patches available?
Thanks,
Chris