↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

The catalog pg_listener supports the LISTEN and NOTIFY commands.

Reading PG 8.4·documented in 6 of 24 versions, 7.4 to 8.4

Historical documentation for a PostgreSQL version that is no longer supported.

Kind
System catalogs
Columns in this snapshot
3
Definition source
English manual

Columns 3

ColumnTypeDescription / reference
relnamenameNotify condition name. (The name need not match any actual relation in the database; the name relname is historical.)
listenerpidint4PID of the server process that created this entry
notificationint4Zero if no event is pending for this listener. If an event is pending, the PID of the server process that sent the notification
Column history across versions
Version history 2
  1. 8.4 → 9.0 removed
  2. 8.1 → 8.2 changed

Definition snapshot: english-manuals:ef7349c2b49f46b716d05b65255… · English manual source