pg_escape with copy
| From: | blackwater dev | Date: | Tue, 26 Feb 2008 02:46:17 +0000 |
| Subject: | pg_escape with copy | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44651@lists.php.net to get a copy of this message | ||
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!