Thread: msquery and double quoting column names

msquery and double quoting column names

From
Giulio Orsero
Date:
7.4.3, latest win odbc drivers.

I see there are many users having problems with mixed case column names
create table t1 ("Field" varchar(8));
and accessing them through msquery (default tool in office suite) due to
msquery not enclosing column names in quotes so that msquery does
    select Field from t1;
and postgres rewrites it into
    select field from t1
thus not finding the column.

I know the solution is to do sql by hand in msquery, but this is not
optimal; so this post is to ask if someone has done one of the
following:

- modified the pgsql win odbc driver to add an option like "quote every
column name before sending it to the server"
- created a patch to postgres server to look for the column name as
typed by the user before lowercasing it.

Thanks.

--
giulioo@pobox.com