note 102508 modified in function.pg-copy-from by danbrown
| From: | danbrown@php.net | Date: | Mon, 21 Feb 2011 15:04:06 +0000 |
| Subject: | note 102508 modified in function.pg-copy-from by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-177186@lists.php.net to get a copy of this message | ||
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