problems with single quotes..

From: "Megalex" <megalex(at)klanomega(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: problems with single quotes..
Date: 2001-01-04 18:57:19
Message-ID: 000b01c07680$29fb2430$0301a8c0@klanomega.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Megalex 2001-01-04 19:50:01 Re: problems with single quotes..
Previous Message Graham Vickrage 2001-01-04 16:04:07 psql -f option