NOTIFY
Specifies the text message to include with a notification.
Syntax
NOTIFY ( 'message', 'notifier', 'target‑topic' )
Parameters
| message |
The message to send to the end point. |
| notifier | The name of the notifier used to deliver the message. |
| target‑topic |
The name of an existing destination Kafka topic for the message. If the topic doesn't already exist, you can configure your Kafka broker to automatically create the specified topic. For more information, see the Kafka documentataion. |
Privileges
Superuser
Examples
Send a message to confirm that an ETL job is complete:
=> SELECT NOTIFY('ETL Done!', 'my_notifier', 'DB_activity_topic');