(PHP 4 >= 4.2.0, PHP 5, PHP 7) Returns the last row's OID string pg_last_oid ( resource $result ) pg_last_oid() is used to retrieve the OID assigned to an inserted row. OID field became an optional field from PostgreSQL 7.2 and will not be present by default in PostgreSQL 8.1. When the OID field is not present in a table, the programmer must use pg_result_status() to check for successful insertion. To get the value of

(PHP 4 >= 4.0.6, PHP 5, PHP 7) Returns the last notice message from PostgreSQL server string pg_last_notice ( resource $connection ) pg_last_notice() returns the last notice message from the PostgreSQL server on the specified connection. The PostgreSQL server sends notice messages in several cases, for instance when creating a SERIAL column in a table. With pg_last_notice(), you can avoid issuing useless queries by ch

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Insert array into table mixed pg_insert ( resource $connection, string $table_name, array $assoc_array [, int $options = PGSQL_DML_EXEC ] ) pg_insert() inserts the values of assoc_array into the table specified by table_name. If options is specified, pg_convert() is applied to assoc_array with the specified options. Parameters: connection

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Get the last error message string of a connection string pg_last_error ([ resource $connection ] ) pg_last_error() returns the last error message for a given connection. Error messages may be overwritten by internal PostgreSQL (libpq) function calls. It may not return an appropriate error message if multiple errors occur inside a PostgreSQL module function. Use pg_result_error(), pg_resu

(PHP 5 >= 5.6.0, PHP 7) Flush outbound query data on the connection mixed pg_flush ( resource $connection ) pg_flush() flushes any outbound query data waiting to be sent on the connection. Parameters: connection PostgreSQL database connection resource. Returns: Returns TRUE if the flush was successful or no data was waiting to be flushed, 0 if

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Gets the backend's process ID int pg_get_pid ( resource $connection ) pg_get_pid() gets the backend's (database server process) PID. The PID is useful to determine whether or not a NOTIFY message received via pg_get_notify() is sent from another process or not. Parameters: connection PostgreSQL database connection resource.

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Free result memory bool pg_free_result ( resource $result ) pg_free_result() frees the memory and data associated with the specified PostgreSQL query result resource. This function need only be called if memory consumption during script execution is a problem. Otherwise, all result memory will be automatically freed when the script ends. Note: This function used to be called pg_freeres

(PHP 4, PHP 5, PHP 7) Returns the host name associated with the connection string pg_host ([ resource $connection ] ) pg_host() returns the host name of the given PostgreSQL connection resource is connected to. Parameters: connection PostgreSQL database connection resource. When connection is not present, the default connection is used. The default connection is the las

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Get asynchronous query result resource pg_get_result ([ resource $connection ] ) pg_get_result() gets the result resource from an asynchronous query executed by pg_send_query(), pg_send_query_params() or pg_send_execute(). pg_send_query() and the other asynchronous query functions can send multiple queries to a PostgreSQL server and pg_get_result() is used to get each query's results, one

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Gets SQL NOTIFY message array pg_get_notify ( resource $connection [, int $result_type ] ) pg_get_notify() gets notifications generated by a NOTIFY SQL command. To receive notifications, the LISTEN SQL command must be issued. Parameters: connection PostgreSQL database connection resource. result_type An