Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group