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(at)malleenet(dot)net(dot)au>
To: "Megalex" <megalex(at)klanomega(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)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