PG_PUBLICATION_TABLES¶
PG_PUBLICATION_TABLES displays the mapping between a publication and its published tables. Unlike the underlying system catalog PG_PUBLICATION_REL, this view expands the publications defined as FOR ALL TABLES and FOR ALL TABLES IN SCHEMA, in which each publishable table has a row. This view is supported only by clusters of version 8.2.0.100 or later.
Column | Type | Description |
|---|---|---|
pubname | Name | Publication name |
schemaname | Name | Name of the schema of a table |
tablename | Name | Table name |
Examples¶
Query all published tables.
SELECT * FROM PG_PUBLICATION_TABLES;
pubname | schemaname | tablename
---------+------------+-----------
mypub | public | t1
mypub | public | t2
(2 rows)