PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8
pg_last_error - Get the last error message string of a connection
Code Examples

pg_last_error( [PgSql\Connection|null$connection = null] ): string

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_result_error_field, pg_result_status and pg_connection_status for better error handling.


This function used to be called pg_errormessage.



An PgSql\Connection instance. When connection is null, the default connection is used. The default connection is the last connection made by pg_connect or pg_pconnect.


As of PHP 8.1.0, using the default connection is deprecated.

Return Values

A string containing the last error message on the given connection.


Version Description
8.1.0 The connection parameter expects an PgSql\Connection instance now; previously, a resource was expected.
8.0.0 connection is now nullable.

Related Functions

Example of pg_last_error

Show all examples for pg_last_error

PHP Version:

Function pg_last_error:

PostgreSQL Functions

Most used PHP functions