Re: Add pg_get_publication_ddl function

Hello!

This generates an invalid statement:

CREATE TABLE rt_ex1 (a int, b int);
CREATE TABLE rt_ex2 (a int, b int);
CREATE PUBLICATION rt_combo FOR ALL SEQUENCES, ALL TABLES EXCEPT
(TABLE rt_ex1, rt_ex2);
SELECT pg_get_publication_ddl('rt_combo');

It switches the tables/sequences order in the output: ".. FOR ALL
TABLES, ALL SEQUENCES EXCEPT .."

And if I only specify "FOR ALL SEQUENCES", it still emits WITH options
that causes a notice. The query succeeds, but maybe this could be
improved?

CREATE PUBLICATION rt_allseq FOR ALL SEQUENCES;
SELECT pg_get_publication_ddl('rt_allseq');

Outputs:

CREATE PUBLICATION rt_allseq FOR ALL SEQUENCES WITH (publish='insert,
update, delete, truncate', publish_generated_columns='none',
publish_via_partition_root='false');
-- NOTICE: publication parameters are not applicable to sequence
synchronization and will be ignored for sequences