数据仓库服务 GaussDB(DWS)-PG_SUBSCRIPTION:应用示例

时间：2025-02-12 15:04:58

应用示例

查看所有订阅：

  
       SELECT * FROM pg_subscription; subdbid | subname | subowner | subenabled |                                       subconninfo                                        | subslotname | subpublications ---------+---------+----------+------------+------------------------------------------------------------------------------------------+-------------+-----------------   15992 | mysub   |       10 | t          | host=1.1.1.1,2.2.2.2 port=10000,20000 dbname=postgres user=repusr1 password=password_123 | mysub       | {mypub}(1 row)