Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to store '

How to store '

From
Henk Jan Barendregt
Date:
Hello,

Is there a way to store a string with the ' character in it ?
I have to import a database with a lot of strings containing the '
character.
If it is not possible i should write a script to replace them with a `
char.

Thanks in advance,

Henk Jan

Re: [INTERFACES] How to store '

From
"Gregory W Burnham"
Date:
You can store the single quote if you escape it first:

This\'s a string that will work

Gregory W Burnham
Software Engineer /
Systems Administrator
Excite Labs
Simon Fraser University
Vancouver, BC
V5A 1S6
604 291 3615 ph
604 291 5679 fx
----- Original Message ----- 
From: Henk Jan Barendregt <henkjan@barendregt.xs4all.nl>
To: <pgsql-interfaces@postgreSQL.org>
Sent: Friday, May 07, 1999 1:02 PM
Subject: [INTERFACES] How to store '


> 
> Hello,
> 
> Is there a way to store a string with the ' character in it ?
> I have to import a database with a lot of strings containing the '
> character.
> If it is not possible i should write a script to replace them with a `
> char.
> 
> Thanks in advance,
> 
> Henk Jan
> 
>

Re: [INTERFACES] How to store '

From
"Brett W. McCoy"
Date:
On Fri, 7 May 1999, Henk Jan Barendregt wrote:

> Is there a way to store a string with the ' character in it ?
> I have to import a database with a lot of strings containing the '
> character.
> If it is not possible i should write a script to replace them with a `
> char.

Escape it with \.

Brett W. McCoy                                                  http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Many people write memos to tell you they have nothing to say.