Difference between revisions of "\dg"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) | + | \du Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) |
[[\dg]] | [[\dg]] |
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: