note 102508 modified in function.pg-copy-from by danbrown
| From: | danbrown@php.net | Date: | Thu, 10 Mar 2011 15:16:34 +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-177743@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\t". $message ."\t300";
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","\t"),
array("\\n","\\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