Request a Demo
Home   >   mailing lists

[PATCH] Add pg_get_subscription_ddl() function - Mailing list pgsql-hackers

From Vaibhav Dalvi
Subject [PATCH] Add pg_get_subscription_ddl() function
Date
Msg-id CA+vB=AGG0NoxWW=-947RBmba8Pzhj8j7op0Xkv8nLDzVMc2=7w@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view
Hi Hackers,

I am submitting a patch as a part of a larger Retail DDL functions
project described by Andrew Dunstan here. This patch creates a
function pg_get_subscription_ddl, designed to retrieve the full DDL
statement for a subscription. Users can obtain the DDL by providing
the subscription name, like so:

  SELECT pg_get_subscription_ddl('testsub1');
                                                                                                                                                                                      pg_get_subscription_ddl                                                                                                                                                                                      
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 CREATE SUBSCRIPTION testsub1 CONNECTION 'dbname=db_doesnotexist' PUBLICATION "testpub1" WITH (connect = false, slot_name = 'testsub1', enabled = false, binary = false, streaming = parallel, synchronous_commit = off, two_phase = off, disable_on_error = off, password_required = on, run_as_owner = off, origin = any, failover = off, retain_dead_tuples = off, max_retention_duration = 0);
(1 row)

This patch includes documentation, comments, and regression tests.

Regards,
Vaibhav Dalvi
EnterpriseDB

Attachment

pgsql-hackers by date:

Previous
From: Alexander Borisov
Date:
Subject: Re: Improve the performance of Unicode Normalization Forms.
Next
From: Peter Eisentraut
Date:
Subject: Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats()