dirkjanfaber/notify json

Last active September 11, 2017 05:14

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dirkjanfaber/f89f77f77c81a1db52af.js"></script>
Save dirkjanfaber/f89f77f77c81a1db52af to your computer and use it in GitHub Desktop.

Download ZIP

JSON notify message for PostgreSQL

Raw

notify json

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

dustinsmith1024 commented Mar 5, 2015

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

Author

dirkjanfaber commented Sep 12, 2016

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.

9659593293 commented Sep 11, 2017

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment