pg_copy_to() copies a table to an array. It issues COPY TO SQL command internally to retrieve records.
COPY TO
PostgreSQL database connection resource.
Name of the table from which to copy the data into rows.
The token that separates values for each field in each element of rows. Default is TAB.
TAB
How SQL NULL values are represented in the rows. Default is \N ("\\N").
NULL
An array with one element for each line of COPY data. It returns FALSE on failure.
COPY
FALSE
<?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);?>