From Xojo Documentation


PostgreSQLDatabase.Notify(name As String)

Supported for all project types and targets.

Sends a notification named "Name".


Clients that have used the Listen method for the name will be get the notification. To receive notifications, call the CheckForNotifications method. Notifications are received in the PostgreSQLDatabase.ReceivedNotification event handler.

The Notify method does not have a way to send a payload. As a workaround you can call the command directly instead:

db.ExecuteSQL("NOTIFY ""UpdateCustomers"", '5, 10, 15'")

Sample Code

Send the "RefreshAll" notification:

// db is a previously connected PostgreSQLDatabase