public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Achilleas Mantzios - cloud <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: postgresql FDW vs dblink for DDL
Date: Mon, 9 Sep 2024 08:31:40 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

On 9/9/24 03:24, Achilleas Mantzios - cloud wrote:
> 
> On 9/8/24 23:46, Adrian Klaver wrote:
>> On 9/8/24 13:04, Achilleas Mantzios wrote:
>>> Hi
>>>
>>> for remote DDL execution (such as CREATE TABLE) is dblink my only 
>>> option?
>>
>> You will need to define in what context you are considering options.
>>
>> For instance you can do remote DDL operations by passing a command or 
>> script via psql.
> 
> Thank you Adrian,
> 
> I was thinking of wrapping the DDL around a FUNCTION that will handle 
> both the local and the (possibly various logical subscriptions), so that 
> my programmers don't need to write extra scripts.
> 
> And the thing is that this creation via DDL is inside our design. 
> Certain users create some backup tables of the public data in their own 
> schema (via our app), then do some manipulations on the public data, 
> then restore to the public or merge with the backups. When done, those 
> backup tables are dropped. So the DDL is inside the app. And the 
> question was if dblink is my only option, in the sense of doing this in 
> a somewhat elegant manner. (and not resort to scripts, etc)

My sense is yes, if you want to encapsulate all of this within the 
database/app you will need to use dblink.

> 
>>
>>>
>>> thanks
>>>
>>>
>>>
>>>
>>

-- 
Adrian Klaver
[email protected]

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: postgresql FDW vs dblink for DDL
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox