Wiki / psql Commands / Describe database objects
\ddp
Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or sche…
Reading PostgreSQL 18.6.
Description
Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode.
- Client
- psql 18.6
- Case-sensitive spelling
- \ddp
Usage
\ddp[x] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \ddp | x |
Manual definition
\ddp[x] [pattern]-
Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If
patternis specified, only entries whose role name or schema name matches the pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode.The
ALTER DEFAULT PRIVILEGEScommand is used to set default 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 11 → 12: changed.
--- PostgreSQL 11
+++ PostgreSQL 12
@@ -1,5 +1,5 @@
{
- "definition": "Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. The ALTER DEFAULT PRIVILEGES command is used to set default access privileges. The meaning of the privilege display is explained under GRANT .",
+ "definition": "Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. The ALTER DEFAULT PRIVILEGES command is used to set default access privileges. The meaning of the privilege display is explained in Section 5.7 .",
"modifiers": [],
"signature": "\\ddp [ pattern ]",
"spellings": [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.