pg_copy_from

说明

bool pg_copy_from ( resource connection, string table_name, array rows [, string delimiter [, string null_as]] )

pg_copy_from() 将数组 rows 的内容作为记录插入表中。它在内部使用了 COPY FROM SQL 命令来插入记录。如果成功则返回 TRUE，失败则返回 FALSE。

add a note User Contributed Notes

vlad at php dot net
20-Mar-2003 05:38


By default NULL values are a backslash followed with capital N ("\\N"). 



Also, you can't insert entries with OIDs (I've added it to my TODO list though)

carl at thep.lu.se
10-Sep-2002 06:06


Something needs to be said about the format of the array.

Judging by what I've seen, it's pretty much what you get

from loading a tab-separated file with file(). That is, the

lines are linefeed-terminated and there's no need to have

an extra line with "\.". On the other hand, when I try using this

command the connection to the server ends up in some odd

state and is then lost:

PHP Warning:  USo() query failed: server closed the connection unexpectedly



I think it might be safer to use the lower-level function

pg_put_line() for now.

17-Jul-2002 02:10


For starters, you can check the first line of every function document. It tells the minimum versions of PHP that you need in order to use the function.

add a note