try using htmlentitites first to conver the ' to ' instead bastien > Date: Mon, 25 Feb 2008 21:46:17 -0500> From: blackwaterdev@xxxxxxxxx> To: php-db@xxxxxxxxxxxxx> Subject: 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! _________________________________________________________________
