PG_END_COPY(3)															    PG_END_COPY(3)

pg_end_copy - Sync with PostgreSQL backend

SYNOPSIS

       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)