Difference between revisions of "\dp"
Jump to navigation
Jump to search
Line 17: | Line 17: | ||
== Related == | == Related == | ||
* [[List tables]]: <code>[[\dt]]</code> | * [[List tables]]: <code>[[\dt]]</code> | ||
+ | * [[List schemas]]: <code>[[\dn]]</code> | ||
* [[sequence]], [[table]] | * [[sequence]], [[table]] | ||
* [[views]] | * [[views]] |
Revision as of 10:23, 28 April 2022
Lists tables, views and sequences with their associated access privileges:
\dp \dp *.*
\dp Access privileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+------------------------------------------+----------+---------------------------------------------+-------------------+----------
Related
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, \conninfo
,--version, --help
, PL/pgSQL
Advertising: