Extend pg_publication_tables to display column list and row filter.
authorAmit Kapila <[email protected]>
Thu, 19 May 2022 02:50:55 +0000 (08:20 +0530)
committerAmit Kapila <[email protected]>
Thu, 19 May 2022 02:50:55 +0000 (08:20 +0530)
commit0ff20288e1cb3282efb43401896a939916fceb4d
treec92b34d13bd072e0c06127b3a8640a25ea4dc917
parent62221ef187b0098c8f331f804b7c63859e5ee6ff
Extend pg_publication_tables to display column list and row filter.

Commit 923def9a53 and 52e4f0cd47 allowed to specify column lists and row
filters for publication tables. This commit extends the
pg_publication_tables view and pg_get_publication_tables function to
display that information.

This information will be useful to users and we also need this for the
later commit that prohibits combining multiple publications with different
column lists for the same table.

Author: Hou Zhijie
Reviewed By: Amit Kapila, Alvaro Herrera, Shi Yu, Takamichi Osumi
Discussion: https://postgr.es/m/202204251548[email protected]
doc/src/sgml/catalogs.sgml
src/backend/catalog/pg_publication.c
src/backend/catalog/system_views.sql
src/backend/replication/logical/tablesync.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/publication.out
src/test/regress/expected/rules.out