Notifying listening clients about database events in a module

Available in

PSQL

The POST_EVENT statement notifies the event manager about the event, which saves it to an event table. When the transaction is committed, the event manager notifies applications that are signalling their interest in the event.

The content of the string can be a string literal, a variable or any valid SQL expression that resolves to a string.

Example

Notifying the listening applications about inserting a record into the table:

SET TERM ^;
CREATE TRIGGER POST_NEW_ORDER FOR SALES
BEGIN
END^