\ddp

\ddp
\ddp *.*

Lists default access privilege settings

• https://www.postgresql.org/docs/14/app-psql.html

https://dba.stackexchange.com/a/184339

\ddp
                               Default access privileges
       Owner       |   Schema    |   Type   |             Access privileges
-------------------+-------------+----------+-------------------------------------------
 user1   | schema1      | table    | usern1=r/user2
 user2 | schema2   | function | user2=X/user3
 user3 | schema3   | sequence | user2=rwU/user3

\ddp
The server (version 8.0) does not support altering default privileges.

Related

• select schema_name from information_schema.schemata;
• \dp
• ALTER DEFAULT PRIVILEGES)

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