pg_publication_rel was added in PostgreSQL 10.
pg_publication_tables provides a human-readable version of this table.
Note that only relations explicitly added to a publication (e.g.
CREATE PUBLICATION ... FOR TABLE ...) will be recorded in this table. Tables in publications which were created with
CREATE PUBLICATION ... FOR ALL TABLES will not be recorded in
pg_publication_rel., but will be visible in
Definition by PostgreSQL version
This table has not been modified since it was added in PostgreSQL 10.
If creating a publication for one or more specified tables, an entry for each table associating it with the publication will be made in :
postgres=# CREATE PUBLICATION test_publication FOR TABLE foo; CREATE PUBLICATION postgres=# SELECT *, prrelid::regclass AS table FROM pg_publication_rel; oid | prpubid | prrelid | table -------+---------+---------+------- 16394 | 16393 | 16390 | foo (1 row)