Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com
	[208.25.171.37]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA31781
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 7 May 1999 16:18:41 -0400 (EDT) (envelope-from ken@ori-ind.com)
Received: from ken (ken.cncware.com [192.168.61.201])
	by cncware.whidbey.com (8.8.7/8.8.7) with SMTP id NAA01344;
	Fri, 7 May 1999 13:17:23 -0700
Message-Id: <3.0.32.19990507132105.008d9a40@ren.cncware.com>
X-Sender: ken_ori@ren.cncware.com
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Fri, 07 May 1999 13:21:07 -0700
To: Henk Jan Barendregt <henkjan@barendregt.xs4all.nl>
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] How to store '
Cc: pgsql-interfaces@postgreSQL.org
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

You have to preceed each occurence of ' with a \.
So "test'string" becomes "test\'string".

Cheers!

Ken

At 08:02 PM 5/7/99 +0000, you wrote:
>
>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
>