RE : MS-QUERY / Postgresql ODBC driver incompatibility - Mailing list pgsql-odbc

From Info Agipa
Subject RE : MS-QUERY / Postgresql ODBC driver incompatibility
Date
Msg-id ADFDC855B3DED14E844ABDEF735A65875041C1FAD6@APLIEX01.exchange.apli.local
Whole thread Raw
In response to Re: MS-QUERY / Postgresql ODBC driver incompatibility  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-odbc
>So what if you do:
>
>select code as "groupe_clients", libelle
>from groupes_clients
I've got an error:
ERREUR: erreur de syntaxe sur ou près de << 'groupe_clients' >>;
Error while executing the query

>Also you might try creating the query in the Query Designer and
>specifying  groupe_clients
>as the alias. This is how I do it I have not had any issues.
I've got the same error

I'm very surprised that you can make it.
It seems MS-QUERY use ' to quote an alias (containing a space or not).
And it seems that pgsql-odbc don't translate it to "




pgsql-odbc by date:

Previous
From: "Prabakaran, Vaishnavi"
Date:
Subject: Re: Configuration error in psqlodbc-09.02.0100 . Help needed!
Next
From: Nils Gösche
Date:
Subject: Re: MS-QUERY / Postgresql ODBC driver incompatibility