pglogical:列出复制集的架构/表部分？

Question

有没有一种方法可以列出添加到replication_set中的所有模式？

# SELECT * FROM pglogical.replication_set;
   set_id   | set_nodeid |       set_name       | replicate_insert | replicate_update | replicate_delete | replicate_truncate
------------+------------+----------------------+------------------+------------------+------------------+--------------------
 1921995266 | 1338498914 | default              | t                | t                | t                | t
 4027572585 | 1338498914 | default_insert_only  | t                | f                | f                | t
 3823354649 | 1338498914 | ddl_sql              | t                | f                | f                | f
 1724847149 | 1338498914 | replication_set | t                | t                | t                | t
(4 rows)
# SELECT pglogical.replication_set_add_all_tables('replication_set', ARRAY['public'],true);
replication_set_add_all_tables
--------------------------------
 t
(1 row)

# SELECT pglogical.replication_set_add_all_tables('replication_set', ARRAY['catalog2'],true);
replication_set_add_all_tables
--------------------------------
 t
(1 row)

Answer 1

pglogical replication_set_table应该提供必要的数据。它包含指向属于给定复制集的架构和表的set_id和set_reloid (schema.table)列。