Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id QAA98902;
	Tue, 4 Jan 2000 16:43:26 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id QAA14681;
	Tue, 4 Jan 2000 16:43:25 -0500 (EST)
To: Michael Meskes <meskes@postgreSQL.org>
cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] escaping characters ... 
In-reply-to: <20000104205359.C814@fam-meskes.de> 
References: <20000104205359.C814@fam-meskes.de>
Comments: In-reply-to Michael Meskes <meskes@postgreSQL.org>
	message dated "Tue, 04 Jan 2000 20:53:59 +0100"
Date: Tue, 04 Jan 2000 16:43:25 -0500
Message-ID: <14678.947022205@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Michael Meskes <meskes@postgreSQL.org> writes:
> On Tue, Jan 04, 2000 at 01:12:58PM -0500, Tom Lane wrote:
>> When generating quoted strings for use in SQL commands, you should
>> prefix single-quote (') and backslash (\) characters with a backslash.

> Isn't the correct way to quote a single-quote with yet another single-quote?

Yeah, doubled '' works too (but only in SQL literals, not in COPY data).
Take your pick...

			regards, tom lane