try using htmlentitites first to conver the ' to ' instead
bastien
> Date: Mon, 25 Feb 2008 21:46:17 -0500> From: [EMAIL PROTECTED]> To:
> php-db@lists.php.net> Subject: [PHP-DB] pg_escape with copy> > I have data
> that I'm running through pg_escape_sting in php and then adding> to stdin for
> a copy command. The problem is "O'reilly" is being changed to> "O''Reilly" in
> the string and then in the db. I saw with the copy command I> can specify the
> escape but it isn't working for me. Should this command fix> this double
> 'single' quote issue when I put it in the db? And what is the> proper
> syntax?> > COPY mytable FROM stdin with escape> > > > Thanks!
_________________________________________________________________
