Re: problems with single quotes..

i already tried escaping it.. but the problem is
with the singlequote-backslash-singlequote combinations..


----- Original Message -----
From: "Horst Herb" <hherb@malleenet.net.au>
To: "Megalex" <megalex@klanomega.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Sunday, December 02, 2001 1:44 AM
Subject: Re: [SQL] problems with single quotes..


> On Friday 05 January 2001 05:57, Megalex wrote:
>
> > everytime i try to run an insert and my text contains '\'
> > it fails..
>
> > Insert Into table(userID,FirstName,LastName) values(1,'''\''','test')
> > and i get this message...
>
> > how can i fix this??
>
> by escaping the '\'
> try
> Insert Into table(userID,FirstName,LastName) values(1,'\\','test')
> ant it will work
>
> CHeers,
> HOrst