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...