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