# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1568662800 -10800
# Node ID c1a29f63c714b86d6f36aa862066b228131673fa
# Parent  5b148ee677de15998d22b4f6b5e67950d3f9558c
List roles.

diff -r 5b148ee677de -r c1a29f63c714 postgres.rst
--- a/postgres.rst	Mon Sep 16 22:33:19 2019 +0300
+++ b/postgres.rst	Mon Sep 16 22:40:00 2019 +0300
@@ -130,6 +130,9 @@
 
   SELECT * FROM pg_roles;
 
+  SELECT oid, rolname FROM pg_roles
+  WHERE pg_has_role('xuser', oid, 'member');
+
 Revoke privileges::
 
   REVOKE ALL PRIVILEGES ON DATABASE mydb FROM xuser;
@@ -176,6 +179,12 @@
 
 Monitor connections
 ===================
+
+Current user::
+
+  SELECT current_user;
+  SELECT session_user;
+
 ::
 
    select * from pg_stat_activity;