method

ReservedSQL.notify

channel: string,

payload?: string

): Promise<void>;

Send a PostgreSQL NOTIFY via pg_notify. Runs as a normal query on this handle, so on a sql.begin() transaction it is delivered on commit and discarded on rollback. Omitting payload sends an empty one, like a bare NOTIFY channel.

await sql.notify("events", JSON.stringify({ id: 1 }));
await sql.notify("cache-invalidated");