Wiki / psql Commands / Describe database objects
\dRp
Lists replication publications. If pattern is specified, only those publications whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, the ta…
Reading PostgreSQL 18.6.
Description
Lists replication publications. If pattern is specified, only those publications whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, the tables and schemas associated with each publication are shown as well.
- Client
- psql 18.6
- Case-sensitive spelling
- \dRp
Usage
\dRp[x+] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dRp | x+ |
Manual definition
\dRp[x+] [pattern]-
Lists replication publications. If
patternis specified, only those publications whose names match the pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, the tables and schemas associated with each publication are shown as well.
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 14 → 15: changed.
--- PostgreSQL 14
+++ PostgreSQL 15
@@ -1,5 +1,5 @@
{
- "definition": "Lists replication publications. If pattern is specified, only those publications whose names match the pattern are listed. If + is appended to the command name, the tables associated with each publication are shown as well.",
+ "definition": "Lists replication publications. If pattern is specified, only those publications whose names match the pattern are listed. If + is appended to the command name, the tables and schemas associated with each publication are shown as well.",
"modifiers": [
{
"command": "\\dRp",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.