postgresql list users
postgres=# dupostgresql list users
postgres=# dupostgres list users
SELECT usename AS role_name,
CASE
WHEN usesuper AND usecreatedb THEN
cast('superuser, create database' AS pg_catalog.text)
WHEN usesuper THEN
cast('superuser' AS pg_catalog.text)
WHEN usecreatedb THEN
cast('create database' AS pg_catalog.text)
ELSE
cast('' AS pg_catalog.text)
END AS role_attributes
FROM pg_catalog.pg_user
ORDER BY role_name DESC;postgres list users and roles
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
, r.rolbypassrls
FROM pg_catalog.pg_roles r
WHERE r.rolname !~ '^pg_'
ORDER BY 1;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
