list_publications
List PostgreSQL logical replication publications with their associated tables, column lists, row filters, and published operations (insert/update/delete/truncate). Run on the publisher.
Instructions
List publications and the tables each carries.
Deterministic. Enumerates pg_publication and pg_publication_tables with per-table column lists, row filters (PG15+), and the published operations (insert/update/delete/truncate). Run this on the PUBLISHER.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |