select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3
Historical version. PostgreSQL 8.3 reached end of support in February 2013. See the current version for supported releases.

dblink_error_message

Name

dblink_error_message -- gets last error message on the named connection

Synopsis

    dblink_error_message(text connname) returns text
   

Description

dblink_error_message fetches the most recent remote error message for a given connection.

Arguments

conname

Name of the connection to use.

Return Value

Returns last error message, or an empty string if there has been no error in this connection.

Example

    SELECT dblink_error_message('dtest1');
   

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.