Wiki / psql Commands / Describe database objects
\dp
Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the pattern are listed. By default only user-created objects are shown; supply a pattern or the S …
Reading PostgreSQL 18.6.
Description
Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the pattern are listed. By default only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode.
- Client
- psql 18.6
- Case-sensitive spelling
- \dp
Usage
\dp[Sx] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dp | Sx |
Manual definition
\dp[Sx] [pattern]-
Lists tables, views and sequences with their associated access privileges. If
patternis specified, only tables, views and sequences whose names match the pattern are listed. By default only user-created objects are shown; supply a pattern or theSmodifier to include system objects. Ifxis appended to the command name, the results are displayed in expanded mode.The
GRANTandREVOKEcommands are used to set access privileges. The meaning of the privilege display is explained in Section 5.8.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 18 → 19: changed.
--- PostgreSQL 18
+++ PostgreSQL 19
@@ -1,5 +1,5 @@
{
- "definition": "Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the pattern are listed. By default only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. The GRANT and REVOKE commands are used to set access privileges. The meaning of the privilege display is explained in Section 5.8 .",
+ "definition": "Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the pattern are listed. By default only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. The GRANT and REVOKE commands are used to set access privileges. The meaning of the privilege display is explained in Section 5.9 .",
"modifiers": [
{
"command": "\\dp",Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.