From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Info Agipa <info(at)apli-agipa(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: MS-QUERY / Postgresql ODBC driver incompatibility |
Date: | 2013-11-05 22:19:14 |
Message-ID: | CANf5jyPsMX=8_=GXE4eoUGYZCq3FAFW9EEwM5H5oFw_19ig+vQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On Tue, Nov 5, 2013 at 5:00 AM, Info Agipa <info(at)apli-agipa(dot)com> wrote:
> Hello.
>
> I've found a problem in using the postgresql ODBC driver with MS-QUERY.
> MS-Query is the tool included in Microsoft Office to access db in excel.
>
> If I type in ms-query :
> select code as groupe_clients, libelle
> from groupes_clients
>
> I have an error message. After some search, it appears that postgresql receive :
> select code as 'groupe_clients', libelle
> from groupe_clients
So what if you do:
select code as "groupe_clients", libelle
from groupes_clients
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.
>
> But postgresql don't want ' but double quote " in the as part.
>
> MS-Query doesn't include a parameter to change this.
>
> It seems to be a ms-query bug...
>
> If no solution exists, I think it's a good idea to include an alert in the faq (http://psqlodbc.projects.pgfoundry.org/faq.html)
>
> As I have searching for a loooong time on google to see what I can make to fix this.
> Am I the only one wich access to postgresql in excel using ms-query and with as clause ?
>
> my ODBC driver version : 8.03.02.00
> my PostgreSQL database version : 8.4.16
>
> Thanks for your attention.
>
> Sylvain Fauveau
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Prabakaran, Vaishnavi | 2013-11-05 22:32:57 | Re: Configuration error in psqlodbc-09.02.0100 . Help needed! |
Previous Message | Info Agipa | 2013-11-05 13:00:31 | MS-QUERY / Postgresql ODBC driver incompatibility |