(PHP 4 >= 4.0.3, PHP 5, PHP 7) Sync with PostgreSQL backend bool pg_end_copy ([ resource $connection ] ) pg_end_copy() syncs the PostgreSQL frontend (usually a web server process) with the PostgreSQL server after doing a copy operation performed by pg_put_line(). pg_end_copy() must be issued, otherwise the PostgreSQL server may get out of sync with the frontend and will report an error. Parameters:

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Deletes records mixed pg_delete ( resource $connection, string $table_name, array $assoc_array [, int $options = PGSQL_DML_EXEC ] ) pg_delete() deletes records from a table specified by the keys and values in assoc_array. If options is specified, pg_convert() is applied to assoc_array with the specified options. Parameters: connection

(PHP 4, PHP 5, PHP 7) Get the database name string pg_dbname ([ resource $connection ] ) pg_dbname() returns the name of the database that the given PostgreSQL connection resource. Parameters: 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(

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Copy a table to an array array pg_copy_to ( resource $connection, string $table_name [, string $delimiter [, string $null_as ]] ) pg_copy_to() copies a table to an array. It issues COPY TO SQL command internally to retrieve records. Parameters: connection PostgreSQL database connection resource. table_name

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Insert records into a table from an array bool pg_copy_from ( resource $connection, string $table_name, array $rows [, string $delimiter [, string $null_as ]] ) pg_copy_from() inserts records into a table from rows. It issues a COPY FROM SQL command internally to insert records. Parameters: connection PostgreSQL database connection reso

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Convert associative array values into suitable for SQL statement array pg_convert ( resource $connection, string $table_name, array $assoc_array [, int $options = 0 ] ) pg_convert() checks and converts the values in assoc_array into suitable values for use in an SQL statement. Precondition for pg_convert() is the existence of a table table_name which has at least as many columns as assoc_

(PHP 5 >= 5.6.0, PHP 7) Reads input on the connection bool pg_consume_input ( resource $connection ) pg_consume_input() consumes any input waiting to be read from the database server. Parameters: connection PostgreSQL database connection resource. Returns: TRUE if no error occurred, or FALSE if there was an error. Note that TRUE does not neces

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Get connection status int pg_connection_status ( resource $connection ) pg_connection_status() returns the status of the specified connection. Parameters: connection PostgreSQL database connection resource. Returns: PGSQL_CONNECTION_OK or PGSQL_CONNECTION_BAD. E

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Reset connection (reconnect) bool pg_connection_reset ( resource $connection ) pg_connection_reset() resets the connection. It is useful for error recovery. Parameters: connection PostgreSQL database connection resource. Returns: Returns TRUE on success or FALSE on failure.

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Get connection is busy or not bool pg_connection_busy ( resource $connection ) pg_connection_busy() determines whether or not a connection is busy. If it is busy, a previous query is still executing. If pg_get_result() is used on the connection, it will be blocked. Parameters: connection PostgreSQL database connection resource.