pg_last_error

PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8
pg_last_error - Get the last error message string of a connection
Manual
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.

Note:

This function used to be called pg_errormessage.

Parameters

connection

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.

Warning:

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.

Changelog

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