PHP: pg_copy_to - Manual

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

search for in the

pg_dbname pg_copy_from

Last updated: Sat, 27 Jan 2007

view this page in

# pg_copy_to

(PHP 4 >= 4.2.0, PHP 5)

pg_copy_to -- Copy a table to an array

## Описание

array pg_copy_to ( resource connection, string table_name [, string delimiter [, string null_as]] )

pg_copy_to() copies a table to an array. It issues `COPY TO` SQL command internally to retrieve records.

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

`connection`

  PostgreSQL database connection resource.

`table_name`

  Name of the table from which to copy the data into `rows`.

`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").

## Возвращаемые значения

An array with one element for each line of `COPY` data. It returns `FALSE` on failure.

## Примеры

Пример 1. pg_copy_to() 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_from()

add a note User Contributed Notes
pg_copy_to
setantae at submonkey dot net
27-Nov-2002 10:50
`"It issues COPY TO SQL command internally to insert records"
I suspect this statement is incorrect, or that s/insert/retrieve/ is appropriate.`
add a note
pg_dbname pg_copy_from

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