Difference between revisions of "\dg"
Jump to navigation
Jump to search
(Redirected page to \du) Tag: New redirect |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | \du Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) | |
+ | |||
+ | [[\dg]] | ||
+ | [[\dg+]] | ||
+ | |||
+ | <pre> | ||
+ | List of roles | ||
+ | Role name | Attributes | Member of | ||
+ | ---------------------+------------------------------------------------------------+------------------------------------------------------------- | ||
+ | </pre> | ||
+ | |||
+ | [[\du]] | ||
+ | [[\du+]] | ||
+ | |||
+ | |||
+ | == See also == | ||
+ | * {{Role}} | ||
+ | * {{GRANT}} | ||
+ | * {{psql}} |
Latest revision as of 15:10, 27 April 2022
\du Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.)
\dg \dg+
List of roles Role name | Attributes | Member of ---------------------+------------------------------------------------------------+-------------------------------------------------------------
\du \du+
See also[edit]
- PostgreSQL: Database roles,
CREATE USER
,CREATE ROLE
,\du, \du+
,create user, Alter user
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, \conninfo
,--version, --help
, PL/pgSQL
Advertising: