(PHP 4, PHP 5, PHP 7) Fetch a row as an object object pg_fetch_object ( resource $result [, int $row [, int $result_type = PGSQL_ASSOC ]] ) object pg_fetch_object ( resource $result [, int $row [, string $class_name [, array $params ]]] ) pg_fetch_object() returns an object with properties that correspond to the fetched row's field names. It can optionally instantiate an object of a specific class, and pass parameters to t

(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 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) 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.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 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.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 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.4.4, PHP 7) Escape a identifier for insertion into a text field string pg_escape_identifier ([ resource $connection ], string $data ) pg_escape_identifier() escapes a identifier (e.g. table, field names) for quering the database. It returns an escaped identifier string for PostgreSQL server. pg_escape_identifier() adds double quotes before and after data. Users should not add double quotes. Use of this funct

(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