Received: from dialup-212.162.15.171.frankfurt1.mik.net (root@dialup-212.162.15.171.frankfurt1.mik.net [212.162.15.171]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA67536 for ; Tue, 4 Jan 2000 14:55:51 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: (from michael@localhost) by dialup-212.162.15.171.frankfurt1.mik.net (8.9.3/8.9.3/Debian 8.9.3-6) id UAA00834 for pgsql-interfaces@postgresql.org; Tue, 4 Jan 2000 20:54:00 +0100 Date: Tue, 4 Jan 2000 20:53:59 +0100 From: Michael Meskes To: PostgreSQL Interfaces Subject: Re: [INTERFACES] escaping characters ... Message-ID: <20000104205359.C814@fam-meskes.de> Mail-Followup-To: PostgreSQL Interfaces Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i 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. > I think that's all. Isn't the correct way to quote a single-quote with yet another single-quote? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!