pg_listener
A former system table providing support for the LISTEN and NOTIFY commands
This entry relates to a PostgreSQL feature, application/utility, website or other subject which is no longer available/maintained.
pg_listener is a former system catalogue table providing support for the LISTEN and NOTIFY commands.
pg_listener was present in all PostgreSQL versions until it was removed in PostgreSQL 9.0.
Definition by PostgreSQL version
pg_listener (PostgreSQL 8.4)
Table "pg_catalog.pg_listener"
Column | Type | Modifiers
--------------+---------+-----------
relname | name | not null
listenerpid | integer | not null
notification | integer | not null
Documentation: pg_listener
pg_listener (PostgreSQL 8.3)
Table "pg_catalog.pg_listener"
Column | Type | Modifiers
--------------+---------+-----------
relname | name | not null
listenerpid | integer | not null
notification | integer | not null
Documentation: pg_listener
pg_listener (PostgreSQL 8.2)
Table "pg_catalog.pg_listener"
Column | Type | Modifiers
--------------+---------+-----------
relname | name | not null
listenerpid | integer | not null
notification | integer | not null
Documentation: pg_listener
Change history
- PostgreSQL 9.0
- removed and replaced by an in-memory queue (commit d1e02722)
References
- PostgreSQL 8.4 documentation: pg_listener