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;");
?>
pg_copy_to
(PHP 4 >= 4.2.0, PHP 5)
pg_copy_to — Copia una tabella in un array
Descrizione
array pg_copy_to
( resource
$connessione
, string $nometabella
[, string $delimitatore
[, string $null_as
]] )
pg_copy_to() copia una tabella in un array.
Internamente utilizza il comando SQL COPY TO per
inserire le tuple. Restituisce l'array risultante. Restituisce
FALSE in caso di errore.
Vedere anche pg_copy_from()
etiger13 at gmail dot com ¶
3 years ago
setantae at submonkey dot net ¶
10 years ago
"It issues COPY TO SQL command internally to insert records"
I suspect this statement is incorrect, or that s/insert/retrieve/ is appropriate.
