There's actually an extension called "tcn" or trigger change notification that p...

eddd-ddde on Feb 10, 2024 | parent | context | favorite | on: Postgres as queue

There's actually an extension called "tcn" or trigger change notification that provides such a trigger put of the box.