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

Categories

Asynchronous notifications, Obsolete, System catalogue

See also

LISTEN, NOTIFY, UNLISTEN