pg_escape with copy

From: 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!

« previous php.db (#44651) next »