Well, you will have to escape the single quotes but you shouldn't have to
escape the newlines, I'm inserting some chunks of text that have all sorts
of newline characters and I'm not escaping them, it seems to work fine..
-Mitch
----- Original Message -----
From: "Alan Horn" <ahorn@inktomi.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, July 24, 2000 10:38 AM
Subject: [GENERAL] Problem with inserting newlines and ' characters
>
> Hi,
>
> This may actually be more of a limitation with the DBD::Pg perl driver.
> I'm not sure.
>
> Basically I'm using DBD::Pg in a perl script which inserts data into a
> very simple table.
>
> The statement I'm using is thus :
>
> my($sth) = $dbh->prepare("insert into maintenance (sno, date, data) values
> ('$sno', '$date', '$tmpstring')");
>
> (all on one line of course...)
>
> My problem is this. $tmpstring may well contain embedded newlines or '
> characters (these are the two characters I've had problems with so far).
>
> I don't want to go down the route of rewriting those characters into
> something 'unique' and decoding whenever I extract information from the
> table. That's always struck me as a bit of a kludge.
>
> So, is it a problem with postgresql, or DBD::Pg, or (most likely) what I'm
> doing with them... ?
>
> Any help much appreciated.
>
> Cheers,
>
> Al
>
>
>
>
>
>
>
