Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f03F1j788556
	for <pgsql-interfaces@postgresql.org>;
	Wed, 3 Jan 2001 10:01:45 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from golem.fourpalms.org (fourpalms.org [64.3.68.148])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f03EGB784554
	for <pgsql-interfaces@postgresql.org>;
	Wed, 3 Jan 2001 09:16:11 -0500 (EST)
	(envelope-from lockhart@fourpalms.org)
Received: from fourpalms.org (localhost.localdomain [127.0.0.1])
	by golem.fourpalms.org (Postfix) with ESMTP
	id 0D958FEA7; Wed,  3 Jan 2001 14:17:16 +0000 (UTC)
Message-ID: <3A53346B.64BA11D6@fourpalms.org>
Date: Wed, 03 Jan 2001 14:17:15 +0000
From: Thomas Lockhart <lockhart@fourpalms.org>
Organization: Yes
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Joseph <lters@mrtc.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Access using Postgres
References: <LOBBJCNOBBADICNFFOCMMEELHGAA.lters@mrtc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/31
X-Sequence-Number: 640

> Does anyone have a utility in access to add backslashes to single quotes for
> the odbc connection to postgres?

Does Access support the SQL9x standard of using two adjacent single
quotes to represent an embedded single quote? PostgreSQL recognizes that
syntax in addition to the backslashed form...

                          - Thomas