Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from pg_stat_activity
- CREATE FUNCTION get_sa() RETURNS SETOF pg_stat_activity AS
- $$ SELECT * FROM pg_catalog.pg_stat_activity; $$
- LANGUAGE sql
- VOLATILE
- SECURITY DEFINER;
- CREATE VIEW pg_stat_activity_allusers AS SELECT * FROM get_sa();
- GRANT SELECT ON pg_stat_activity_allusers TO public;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement