pg_copy_from

(PHP 4 >= 4.2.0, PHP 5, PHP 7)

pg_copy_from — 根据数组将记录插入表中

说明

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

pg_copy_from() 将数组 rows 的内容作为记录插入表中。它在内部使用了 COPY FROM SQL 命令来插入记录。

参数

connection: PostgreSQL database connection resource.
table_name: Name of the table into which to copy the rows.
rows: An array of data to be copied into table_name. Each value in rows becomes a row in table_name. Each value in rows should be a delimited string of the values to insert into each field. Values should be linefeed terminated.
delimiter: The token that separates values for each field in each element of rows. Default is TAB.
null_as: How SQL NULL values are represented in the rows. Default is \N ("\N").

返回值

成功时返回 TRUE，或者在失败时返回 FALSE。

范例

Example #1 pg_copy_from() example

 <?php
   $db = pg_connect("dbname=publisher") or die("Could not connect");
   
   $rows = pg_copy_to($db, $table_name);
   
   pg_query($db, "DELETE FROM $table_name");
   
   pg_copy_from($db, $table_name, $rows);
?>

参见

pg_copy_to() - 将一个表拷贝到数组中