Re: [GENERAL] Apostrophes et al in a files with text attribute

Marc G. Fournier <scrappy@hub.org>

From: The Hermit Hacker <scrappy@hub.org>
To: The Web Administrator <wwwadmin@wizard.ca>
Cc: PostGres General Questions <pgsql-general@postgreSQL.org>
Date: 1998-05-15T13:51:45Z
Lists: pgsql-general
On Fri, 15 May 1998, The Web Administrator wrote:

> I have passed text via a Perl CGI to my database, and tried storing text
> 
> into a field with the text attribute.  Only problem is if there is an
> apostrophe in the string as in the word "can't"
> it will not INSERT.... hmm... isn't "isn't" text?
> 
> hehehe.. anyways, what is the usual work around?

escape it with a \ and it will work...