PG_END_COPY(3)PG_END_COPY(3)pg_end_copy - Sync with PostgreSQL backendSYNOPSIS
bool pg_end_copy ([resource $connection])
DESCRIPTION pg_end_copy(3) syncs the PostgreSQL frontend (usually a web server process) with the PostgreSQL server after doing a copy operation per-
formed by pg_put_line(3). pg_end_copy(3) must be issued, otherwise the PostgreSQL server may get out of sync with the frontend and will
report an error.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
pg_end_copy(3) example
<?php
$conn = pg_pconnect("dbname=foo");
pg_query($conn, "create table bar (a int4, b char(16), d float8)");
pg_query($conn, "copy bar from stdin");
pg_put_line($conn, "3 hello world 4.5
");
pg_put_line($conn, "4 goodbye world 7.11
");
pg_put_line($conn, "\.
");
pg_end_copy($conn);
?>
SEE ALSO pg_put_line(3).
PHP Documentation Group PG_END_COPY(3)