pg_end_copy
(PHP 4 >= 4.0.3, PHP 5, PHP 7, PHP 8)
pg_end_copy — 與 PostgreSQL 後端同步
說明
pg_end_copy(resource
$connection
= ?): boolpg_end_copy() 在處理完 pg_put_line() 所執行的拷貝操作之後將 PostgreSQL 前端(通常為 web server 程序)與 PostgreSQL 伺服器進行同步。pg_end_copy() 必須被呼叫,否則 PostgreSQL 伺服器可能會和前端失去同步並報錯。
參數
-
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() or pg_pconnect().
返回值
成功時返回 true
, 或者在失敗時返回 false
。
範例
示例 #1 pg_end_copy() 例子
<?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\thello world\t4.5\n");
pg_put_line($conn, "4\tgoodbye world\t7.11\n");
pg_put_line($conn, "\.\n");
pg_end_copy($conn);
?>