blackwater dev wrote:
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?


AFAIK "copy" takes the csv file and imports it (and handles quotes etc itself).

So just create your file:

First Name, Last Name
Tim, O'Reilly

and when you "copy" that in (without the header line), it'll "just work".

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to