RE: [PHP-DB] pg_escape with copy
| From: | Bastien Koert | Date: | Tue, 26 Feb 2008 14:08:07 +0000 |
| Subject: | RE: [PHP-DB] pg_escape with copy | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44654@lists.php.net to get a copy of this message | ||
try using htmlentitites first to conver the ' to ' instead
bastien
> Date: Mon, 25 Feb 2008 21:46:17 -0500> From: blackwaterdev@gmail.com> 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!
_________________________________________________________________