Received: from dagny.flutterby.com (www.flutterby.com [209.140.49.28]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0PICqq86917 for ; Thu, 25 Jan 2001 13:12:52 -0500 (EST) (envelope-from danlyke@flutterby.com) Received: from wynand.flutterby.com (adsl-64-163-66-178.dsl.snfc21.pacbell.net [64.163.66.178]) by dagny.flutterby.com (8.9.3/8.9.3/Debian/GNU) with ESMTP id JAA01601; Thu, 25 Jan 2001 09:53:13 -0800 Received: (from danlyke@localhost) by wynand.flutterby.com (8.9.3/8.9.3/Debian 8.9.3-21) id KAA00706; Thu, 25 Jan 2001 10:03:40 -0800 From: Dan Lyke MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14960.27260.603134.688706@wynand.flutterby.com> Date: Thu, 25 Jan 2001 10:03:40 -0800 (PST) To: Alessio Bragadini Cc: Markus Wagner , "pgsql-sql@postgresql.org" Subject: Re: "'" in SQL INSERT statement In-Reply-To: <3A700060.3FD31A6D@albourne.com> References: <3A6FFC12.F5ABA71@imsd.uni-mainz.de> <3A700060.3FD31A6D@albourne.com> X-Mailer: VM 6.72 under 21.1 (patch 10) "Capitol Reef" XEmacs Lucid X-Archive-Number: 200101/359 X-Sequence-Number: 1032 Alessio Bragadini writes: > Markus Wagner wrote: > > I have some data that I wish to transfer into a database using perl/DBI. > > If you use Perl DBI you should issue statements like > $dbh->do ('INSERT INTO table (field1, field2) VALUES (?,?)', > undef, $value1, $value2); $dbh->quote() also puts in the appropriate escapes, ala: $dbh->do('INSERT INTO TABLE (field) VALUES ('.$dbh->quote($value).')'); Dan