Search code examples
postgresqlnotifylisten

How can I send column values as the payload in a postgresql NOTIFY message?


If an entry in a table satisfies certain conditions, a NOTIFY is sent out. I want the payload to include the ID number and several other columns of information. Is there a postgres method to convert variables (OLD.ColumnID, etc) to strings?

using postgres 9.3


Solution

  • The solution was to upgrade Postgres to a version that supported JSON.