(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

pg_result_error Get error message associated with result


pg_result_error(PgSql\Result $result): string|false

pg_result_error() returns any error message associated with the result instance. Therefore, the user has a better chance of getting the correct error message than with pg_last_error().

The function pg_result_error_field() can give much greater detail on result errors than pg_result_error().

Because pg_query() returns false if the query fails, you must use pg_send_query() and pg_get_result() to get the result handle.



An PgSql\Result instance, returned by pg_query(), pg_query_params() or pg_execute()(among others).

Return Values

Returns a string. Returns empty string if there is no error. If there is an error associated with the result parameter, returns false.


Version Description
8.1.0 The result parameter expects an PgSql\Result instance now; previously, a resource was expected.


Example #1 pg_result_error() example

pg_connect("dbname=publisher") or die("Could not connect");

  if (!
pg_connection_busy($dbconn)) {
pg_send_query($dbconn"select * from doesnotexist;");
$res1 pg_get_result($dbconn);

See Also