problems with single quotes.. - Mailing list pgsql-sql

From Megalex
Subject problems with single quotes..
Date
Msg-id 000b01c07680$29fb2430$0301a8c0@klanomega.com
Whole thread Raw
In response to Re: Unexpected Return from Function  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: problems with single quotes..
Re: problems with single quotes..
Re: problems with single quotes..
Re: problems with single quotes..
List pgsql-sql
ok.. here is my deal..

everytime i try to run an insert and my text contains '\'
it fails..

an sql example would be.

Insert Into table(userID,FirstName,LastName) values(1,'''\''','test')
and i get this message...

Error while executing the query; ERROR: parser: parse error at or near
"test"

how can i fix this??

Alex,









pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Unexpected Return from Function
Next
From: Horst Herb
Date:
Subject: Re: problems with single quotes..