From 620937b4ddc23625a0061b3323a9451d8cca928c Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 13 Sep 2016 18:29:41 +0200
Subject: [PATCH] pg.sh

---
 etc/profile.d/pg.sh | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/etc/profile.d/pg.sh b/etc/profile.d/pg.sh
index 8ee920ce..ecf2ea59 100644
--- a/etc/profile.d/pg.sh
+++ b/etc/profile.d/pg.sh
@@ -26,3 +26,7 @@ pg_count() {
 
     cd $pwd
 }
+
+pg_users() {
+  psql template1 -c "SELECT r.rolname, r.rolsuper, r.rolinherit, r.rolcreaterole, r.rolcreatedb, r.rolcanlogin, r.rolconnlimit, r.rolvaliduntil, ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_members m JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid) WHERE m.member = r.oid) as memberof , r.rolreplication FROM pg_catalog.pg_roles r ORDER BY 1"
+}
-- 
2.47.3