pg_copy_from

(PHP 4 >= 4.2.0, PHP 5)

pg_copy_from --  Insert records into a table from an array

Описание

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

pg_copy_from() inserts records into a table from rows. It issues a COPY FROM SQL command internally to insert records.

Список параметров

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 в случае возникновения ошибки.

Примеры

Пример 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()



pg_copy_from
vlad at php dot net
19-Mar-2003 01: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 03: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.
16-Jul-2002 11: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.

<pg_convertpg_copy_to>
 Last updated: Tue, 15 Nov 2005