note 102508 modified in function.pg-copy-from by danbrown

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","\t"),
  array("\\n","\\r","\\t"),
  $message);

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

pg_copy_from($db, "message", $copy_message, ";");
?>

--was--
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, ";");
?>

http://php.net/manual/en/function.pg-copy-from.php