function for pg_notify

[yaitskov]

Hi,

I explore PostgreSQL listen/notify feature. There is a getNotification function but there is not wrapper function for sending notifications. I can use pg_notify and select, but it doesn't look symmetrical.

[wraithm]

You can do execute_ conn "NOTIFY <channel>, <payload>"

as described here: https://www.postgresql.org/docs/14/sql-notify.html