MS Query does not quote identifiers in the generated SQL
Out users need to analyze data in a Postgres database. The Schema, table,
and field names are all in UPPER case. After selecting the particular
datasource, MS Query Wizard correctly presents the tables, and upon choosing
a table correctly displays all the fields. After choosing the desired
fields, and then executing the query, a tombstone appears saying 'Error:
Schema "scott" does not exist'. This is true because the name is "SCOTT"
not "scott". If I manually type the SQL, and include the appropriate
quotes, the select works fine.
I have tested this with both Excel 2002 and Excel 2007 with the same result.
Is there a way to cause the MS Query Wizard to fill in the appropriate
quotes? Is there another workaround?
|