pg_copy_to

pg_copy_to

Copy a table to an array

 **pg_copy_to** PgSql\Connection $connection string $table_name string $separator string $null_as

copies a table to an array. It

issues SQL command internally to retrieve records. pg_copy_to``COPY TO

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

separator The token that separates values for each field in each element of . Default is . rows``\t

null_as How SQL values are represented in the . Default is (). NULL``rows``\\N``"\\\\N"

An  with one element for each line of  data, return.falseforfailure.

array``COPY

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