Skip site navigation (1) Skip section navigation (2)

Problems Escaping quotes by backslash with PsqlODBC

From: "Walter, Gregor" <GW(at)GlobalFulfillment(dot)com>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Problems Escaping quotes by backslash with PsqlODBC
Date: 2000-04-11 09:31:19
Message-ID: F7DE1390D677D2118EFB0008C7A4335023A9C1@DESDC01 (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

I am using the pgadmin windows tool with the latest PsqlODBC drivers.
The problem seems to be, that running a query with escaped quotes like
[Select * from test where xyz like 'pete\'s cafe'] doesnt work, but
using 2 single quotes works: [Select * from test where xyz like 'pete''s
But I can run both queries on the psql command line interface on linux.

Can this be a problem with the ODBC or is there a setting that can be
changed to also allow both ways?

Gregor Walter

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-04-11 09:49:19
Subject: RE: ODBC and crypted passwords
Previous:From: Byron NikolaidisDate: 2000-04-11 03:50:29
Subject: Re: query from Murty

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group