Skip to content
masterclass Buddy

PostgreSQL · Command

LISTEN

LISTEN subscribes a PostgreSQL session to a notification channel. The session receives events when NOTIFY uses that channel.

Last updated

Syntax

LISTEN channel;

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • NOTIFY
  • UNLISTEN
  • PQnotifies
  • max_notify_queue_pages

Source: PostgreSQL: Documentation: 18: LISTEN. Checked 2026-11-03.