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

From Horst Herb
Subject Re: problems with single quotes..
Date
Msg-id 20011202073819.28521.qmail@gnumed.dhs.org
Whole thread Raw
In response to problems with single quotes..  ("Megalex" <megalex@klanomega.com>)
List pgsql-sql
On Friday 05 January 2001 05:57, Megalex wrote:

> everytime i try to run an insert and my text contains '\'
> it fails..

> Insert Into table(userID,FirstName,LastName) values(1,'''\''','test')
> and i get this message...

> how can i fix this??

by escaping the '\'
try
Insert Into table(userID,FirstName,LastName) values(1,'\\','test')
ant it will work

CHeers,
HOrst


pgsql-sql by date:

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