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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: The Web Administrator <wwwadmin(at)wizard(dot)ca>
Cc: PostGres General Questions <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Apostrophes et al in a files with text attribute
Date: 1998-05-15 13:51:45
Message-ID: Pine.BSF.3.96.980515095107.17015F-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Good 1998-05-15 14:05:22 subscribe
Previous Message The Web Administrator 1998-05-15 13:08:56 Apostrophes et al in a files with text attribute