Re: problems with single quotes..

Megalex wrote:

> 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??

It isn't clear to me what literal you're trying to insert, but it looks 
like it's either:

vsreg_192=# select '\'\'\\\'\''; ?column?
---------- ''\''
(1 row)

or

vsreg_192=# select '\'\\\''; ?column?
---------- '\'
(1 row)

HTH,

Joe