Обсуждение: "[" is a nuisance...

Hi all,

I'm using the PostreSQL30 ODBC driver to hook a Windows app to a 7.4.1
PostreSQL DB.  Might be the driver, or it might be the app itself (I don't
have access to the app), but I'm getting this coming across the wire:

SELECT * FROM [PARTID];

[PARTID] is giving it fits.  Wants to see PARTID.

Is there any way for postmaster to filter this out?  If not, is there anyway
for the ODBC driver to filter this out (in the event the driver itself isn't
actually generating this) short of ripping open the source?

Cheers,
Mike

"Michael J. Conroy" <m_j_conroy@yahoo.com> writes:
> I'm using the PostreSQL30 ODBC driver to hook a Windows app to a 7.4.1
> PostreSQL DB.  Might be the driver, or it might be the app itself (I don't
> have access to the app), but I'm getting this coming across the wire:

> SELECT * FROM [PARTID];

IIRC there is some database (likely Microsoft but I don't recall for
sure) that uses this syntax to quote identifiers --- that is, the
SQL-standard spelling of this query would be

  SELECT * FROM "PARTID";

> Is there any way for postmaster to filter this out?  If not, is there anyway
> for the ODBC driver to filter this out (in the event the driver itself isn't
> actually generating this) short of ripping open the source?

The PG ODBC driver certainly isn't generating it.  I dunno if there is
any existing code in that driver to do such a conversion --- try asking
on the pgsql-odbc list.

            regards, tom lane