Difference between revisions of "List users and roles: \du"
Jump to navigation
Jump to search
Line 20: | Line 20: | ||
− | <code> SELECT rolname FROM [[pg_roles]]; </code> | + | * <code> SELECT rolname FROM [[pg_roles]]; </code> |
Revision as of 13:23, 26 January 2022
List users and Roles https://www.postgresql.org/docs/current/app-psql.html
Lists database roles. (Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg
.) By default, only user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only those roles whose names match the pattern are listed. If the form \du+
is used, additional information is shown about each role; currently this adds the comment for each role.
\du
\du+
List roles using \du
command:
postgres=# \du List of roles Role name | Attributes | Member of ----------------+------------------------------------------------------------+----------- YOUR_USER | Create DB | {} YOUR_USER2 | Cannot login | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
SELECT rolname FROM pg_roles;
Related terms
See also
GRANT
,\ddp
,GRANT USAGE
,GRANT ALL PRIVILEGES
,GRANT SELECT
, View GRANTs on Redshift,has_table_privilege
,has_schema_privilege
,HAS_DATABASE_PRIVILEGE
,SCHEMA
, Privileges,GRANT EXECUTE
- PostgreSQL:
psql
,.psqlrc, .pgpass
,$HOME/.pg service.conf
,-U, -W, -d
, meta-commands:\du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q
,show users
,show
,su - postgres
,psql -c, \?, \connect
,--version, --help
, PL/pgSQL
Advertising: