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

时间：2024-09-24 17:40:41

应用示例

查看所有订阅：

  
       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)