Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Apostrophes et al in a files with text attribute - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: [GENERAL] Apostrophes et al in a files with text attribute
Date
Msg-id Pine.BSF.3.96.980515095107.17015F-100000@hub.org
Whole thread Raw
In response to Apostrophes et al in a files with text attribute  (The Web Administrator <wwwadmin@wizard.ca>)
List pgsql-general
Tree view 
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...

pgsql-general by date:

Previous
From: The Web Administrator
Date:
Subject: Apostrophes et al in a files with text attribute
Next
From: Thomas Good
Date:
Subject: subscribe