note 102508 added to function.pg-copy-from
| From: | Dave at osu1 dot php dot net | Date: | Fri, 18 Feb 2011 10:39:45 +0000 |
| Subject: | note 102508 added to function.pg-copy-from | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-177101@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","\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