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;

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