diff options
Diffstat (limited to 'doc/src/sgml/ref/create_subscription.sgml')
-rw-r--r-- | doc/src/sgml/ref/create_subscription.sgml | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index 4c2db4c30d..71652fd918 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -496,12 +496,14 @@ CREATE SUBSCRIPTION <replaceable class="parameter">subscription_name</replaceabl other subscriptions created on the publisher) try this SQL query: <programlisting> # substitute <pub-names> below with your publication name(s) to be queried -SELECT DISTINCT N.nspname AS schemaname, C.relname AS tablename -FROM pg_publication P, - LATERAL pg_get_publication_tables(P.pubname) GPT - JOIN pg_subscription_rel PS ON (GPT.relid = PS.srrelid), - pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace) -WHERE C.oid = GPT.relid AND P.pubname IN (<pub-names>); +SELECT DISTINCT PT.schemaname, PT.tablename +FROM pg_publication_tables PT, + pg_subscription_rel PS + JOIN pg_class C ON (C.oid = PS.srrelid) + JOIN pg_namespace N ON (N.oid = C.relnamespace) +WHERE N.nspname = PT.schemaname AND + C.relname = PT.tablename AND + PT.pubname IN (<pub-names>); </programlisting></para> </refsect1> |