51.52. pg_subscription
目錄 pg_subscription 包含所有現有訂閱的邏輯複寫。有關邏輯複寫的相關資訊,請參閱第 30 章。
與大多數系統目錄不同,pg_subscription 在叢集的所有資料庫之間是共享的:每個叢集只有一個 pg_subscription,而不是每個資料庫一個。
普通使用者沒有權限讀取 subconninfo 欄位,因為該欄位可能包含純文字密碼。
Table 51.52. pg_subscription
Columns
pg_subscription
ColumnsColumn Type Description |
Row identifier |
OID of the database which the subscription resides in |
Name of the subscription |
Owner of the subscription |
If true, the subscription is enabled and should be replicating. |
Connection string to the upstream database |
Name of the replication slot in the upstream database (also used for the local replication origin name); null represents |
Contains the value of the |
|
Last updated