"blackwater dev" <blackwaterdev@xxxxxxxxx> writes: > 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. pg_escape_string is designed to produce a string properly quoted for use as a literal in a SQL command. It is completely wrong for data that is to go into COPY input. I kinda doubt that PHP has anything built-in that's suitable for COPY, though I could be wrong ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
