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

From Stephan Szabo
Subject Re: problems with single quotes..
Date
Msg-id 20011201234829.F77227-100000@megazone23.bigpanda.com
Whole thread Raw
In response to problems with single quotes..  ("Megalex" <megalex@klanomega.com>)
List pgsql-sql
On Thu, 4 Jan 2001, 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??

You'll need to backslash escape that backslash.



pgsql-sql by date:

Previous
From: "Megalex"
Date:
Subject: Re: problems with single quotes..
Next
From: Joe Conway
Date:
Subject: Re: problems with single quotes..