(PHP 4 >= 4.2.0, PHP 5, PHP 7) Test if a field is SQL NULL int pg_field_is_null ( resource $result, int $row, mixed $field ) int pg_field_is_null ( resource $result , mixed $field ) pg_field_is_null() tests if a field in a PostgreSQL result resource is SQL NULL or not. Note: This function used to be called pg_fieldisnull(). Parameters: result PostgreSQL query res

(PHP 4, PHP 5, PHP 7) Fetch a row as an array array pg_fetch_array ( resource $result [, int $row [, int $result_type = PGSQL_BOTH ]] ) pg_fetch_array() returns an array that corresponds to the fetched row (record). pg_fetch_array() is an extended version of pg_fetch_row(). In addition to storing the data in the numeric indices (field number) to the result array, it can also store the data using associative indices (field

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Fetch a row as an associative array array pg_fetch_assoc ( resource $result [, int $row ] ) pg_fetch_assoc() returns an associative array that corresponds to the fetched row (records). pg_fetch_assoc() is equivalent to calling pg_fetch_array() with PGSQL_ASSOC as the optional third parameter. It only returns an associative array. If you need the numeric indices, use pg_fetch_row(). Note:

(PHP 5 >= 5.1.0, PHP 7) Sends a request to execute a prepared statement with given parameters, and waits for the result. resource pg_execute ([ resource $connection ], string $stmtname, array $params ) Sends a request to execute a prepared statement with given parameters, and waits for the result. pg_execute() is like pg_query_params(), but the command to be executed is specified by naming a previously-prepared statemen

(PHP 4 >= 4.3.0, PHP 5, PHP 7) Fetches all rows from a result as an array array pg_fetch_all ( resource $result ) pg_fetch_all() returns an array that contains all rows (records) in the result resource. Note: This function sets NULL fields to the PHP NULL value. Parameters: result PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute

(PHP 5 >= 5.4.4, PHP 7) Escape a literal for insertion into a text field string pg_escape_literal ([ resource $connection ], string $data ) pg_escape_literal() escapes a literal for querying the PostgreSQL database. It returns an escaped literal in the PostgreSQL format. pg_escape_literal() adds quotes before and after data. Users should not add quotes. Use of this function is recommended instead of pg_escape_string().

(PHP 5 >= 5.1.0, PHP 7) Fetches all rows in a particular result column as an array array pg_fetch_all_columns ( resource $result [, int $column = 0 ] ) pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the result resource. Note: This function sets NULL fields to the PHP NULL value. Parameters: result PostgreSQL query re

(PHP 4 >= 4.2.0, PHP 5, PHP 7) Escape a string for query string pg_escape_string ([ resource $connection ], string $data ) pg_escape_string() escapes a string for querying the database. It returns an escaped string in the PostgreSQL format without quotes. pg_escape_literal() is more preferred way to escape SQL parameters for PostgreSQL. addslashes() must not be used with PostgreSQL. If the type of the column is bytea, p

(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.2.0, PHP 5, PHP 7) Escape a string for insertion into a bytea field string pg_escape_bytea ([ resource $connection ], string $data ) pg_escape_bytea() escapes string for bytea datatype. It returns escaped string. Note: When you SELECT a bytea type, PostgreSQL returns octal byte values prefixed with '\' (e.g. \032). Users are supposed to convert back to binary format manually. This function requires Pos