Re: problems with single quotes..

From: Horst Herb <hherb(at)malleenet(dot)net(dot)au>
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:44:04
Message-ID: 20011202073819.28521.qmail@gnumed.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-12-02 07:48:57 Re: problems with single quotes..
Previous Message Stephan Szabo 2001-12-02 02:23:10 Re: Unexpected Return from Function