"It issues COPY TO SQL command internally to insert records"
I suspect this statement is incorrect, or that s/insert/retrieve/ is appropriate.
(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_copy_to — Copiar una tabla a un array
$connection
,$table_name
,$delimiter
= ?,$null_as
= ?
pg_copy_to() Copia una tabla a un array.
COPY TO
hace comandos SQL internamente para
recurperar los registros.
connection
Recurso de conexión de base de datos PostgreSQL.
table_name
Nombre de la tabla de la que se copia los datos en rows
.
delimiter
El símbolo que separa los valores para cada campo en cada elemento de las
rows
. Por defecto es un TAB
.
null_as
Como se representan los valores NULL
en las
rows
. Por defecto es \N ("\\N").
Un array con un elemento por cada linea de datos COPY
.
Este devuelve false
en caso de fallo.
Ejemplo #1 Ejemplo de pg_copy_to()
<?php
$db = pg_connect("dbname=publisher") or die("No se ha podido conectar");
$rows = pg_copy_to($db, $table_name);
pg_query($db, "DELETE FROM $table_name");
pg_copy_from($db, $table_name, $rows);
?>
"It issues COPY TO SQL command internally to insert records"
I suspect this statement is incorrect, or that s/insert/retrieve/ is appropriate.
Worth noting here that just like the COPY TO statement in PostgreSQL, '$table_name' can include a list of columns or be a select query as well.
e.g.:
$rows = pg_copy_to($db,'schema."TableName" (column1, column2, ...)';
$rows = pg_copy_to($db,'(SELECT ...)');
You cannot specify the schema name in this command. You can change the search path for just one query by using the following code:
<?php
pg_query($conn, "SET search_path TO myschema;");
$copy_to = pg_copy_to($conn, 'tablename');
pg_query("RESET search_path;");
?>