JSON notify message for PostgreSQL

notify json

 select pg_notify('json', row_to_json(x)::text) as notify 
 from (select 'hello world' as message, 42 as answer ) x;

In this case 'json' is the channel to listen to, the message to send over the channel is:

{"message":"hello world","answer":42}

Asynchronous notification "json" with payload "{"message":"hello world","answer":42}" received from server process with PID 17306.

Use this code in combination with a 'LISTEN json;'

randomly found this, thanks. Do you have issues with message size ever? I noticed the pg doc recommended never sending messages over 8000 bytes.

I never send too large messages with the notifications. If a message would become too long, I'd probably add a link to the complete message in one of the json fields. Or an id + view on how to fetch the needed extra info.

Thanks for your post.It is very use full for me.