PHP: pg_copy_from - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

pg_copy_to pg_convert

Last updated: Sat, 27 Jan 2007

view this page in

# 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()

add a note User Contributed Notes
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: U�S�o() 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.`
add a note
pg_copy_to pg_convert

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST