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