note 102508 added to function.pg-copy-from

[email protected] Fri, 18 Feb 2011 02:39:45 -0800
Newsgroups php.notes
Message-ID <[email protected]>
Fix for "Copy command failed: ERROR: literal carriage return
found in data" or 
"Copy command failed: ERROR: missing data for column
"message" CONTEXT: COPY message, line 1:"

<?php
$message = "HEJ\rHEJ\nHEJ\r\nHEJ\n\rHEJ\tHELLO\\";

$message = addslashes($message);

$message = str_replace(
  array("\n\r","\r\n","\n","\r","\t"),
  array("\r","\r","\r","\\r","\\t"),
  $message);

$copy_message = "1;". $message .";300";

pg_copy_from($db, "message", $copy_message, ";");
?>
----
Server IP: 69.147.83.197
Probable Submitter: 88.131.54.66
----
Manual Page -- http://www.php.net/manual/en/function.pg-copy-from.php
Edit        -- https://master.php.net/note/edit/102508
Del: integrated  -- https://master.php.net/note/delete/102508/integrated
Del: useless     -- https://master.php.net/note/delete/102508/useless
Del: bad code    -- https://master.php.net/note/delete/102508/bad+code
Del: spam        -- https://master.php.net/note/delete/102508/spam
Del: non-english -- https://master.php.net/note/delete/102508/non-english
Del: in docs     -- https://master.php.net/note/delete/102508/in+docs
Del: other reasons-- https://master.php.net/note/delete/102508
Reject      -- https://master.php.net/note/reject/102508
Search      -- https://master.php.net/manage/user-notes.php