On Fri, Oct 29, 2021 at 3:35 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > Sawada-San, others, what do you think? Is it really useful to have such a > view? > > One point to think is if we introduce such a view then how it should > behave for schema objects? Do we need to display only schemas or > additionally all the tables in the schema as well? If you follow the > above suggestion of mine then I think it will display both schemas > published and tables in that schema that will be considered for > publishing. >
I find the proposed view useful for processing the publication structure and members in SQL, without having to piece the information together from the other pg_publication_* tables. Personally I don't think it is necessary to additionally display all tables in the schema (that information can be retrieved by pg_tables or information_schema.tables, if needed). Regards, Greg Nancarrow Fujitsu Australia
