Difference between revisions of "\dg"
Jump to navigation
Jump to search
| (3 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]] | ||
[[\dg+]] | [[\dg+]] | ||
| + | <pre> | ||
| + | List of roles | ||
| + | Role name | Attributes | Member of | ||
| + | ---------------------+------------------------------------------------------------+------------------------------------------------------------- | ||
| + | </pre> | ||
[[\du]] | [[\du]] | ||
| Line 8: | Line 15: | ||
== See also == | == 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:
