If you're using DBD::Pg, just use ? placeholders without any quotes and let
it do the escaping for you:
$sth = $dbh->prepare("insert into customer (name) values (?)");
$sth->execute($name);
Makes the code a little more portable too. Hope this helps,
Wes
dave_h4@yahoo.com (Hunter)@postgresql.org on 11/22/2002 08:00:31 AM
Sent by: pgsql-general-owner@postgresql.org
To: pgsql-general@postgresql.org
cc:
Subject: [GENERAL] escape single quote in INSERT command
Hi Group -
I have a perl application for a registration form. I'd like to put
escape characters in my insert command to accommodate for '
(i.e. O'Brien, O'Malley, etc). I've tired double quotes, single
quotes, back tick, forward ticks, curly bracket, round brackets - no
success.
Thanks, dave
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org