	О проекте
	Руководство php

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_to

pg_convert

Last updated: Sat, 27 Jan 2007

add a note User Contributed Notes
pg_copy_from

kapouer_php at melix dot org
26-Aug-2007 02:24


pg syntax is :

COPY test (cola, colb, colc) FROM stdin;

...



this function doesn't let you in which order the columns are !

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:  U

Новости

11 июля 2007
Сайт запущен