Re: problems with single quotes..

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Megalex <megalex(at)klanomega(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: problems with single quotes..
Date: 2001-12-02 07:48:57
Message-ID: 20011201234829.F77227-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2001-12-02 14:52:09 Re: problems with single quotes..
Previous Message Horst Herb 2001-12-02 07:44:04 Re: problems with single quotes..