public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Achilleas Mantzios - cloud <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: postgresql FDW vs dblink for DDL
Date: Mon, 09 Sep 2024 11:40:00 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Adrian Klaver <[email protected]> writes:
> On 9/9/24 03:24, Achilleas Mantzios - cloud wrote:
>> 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.

postgres_fdw certainly can't do it, nor any other FDW -- the FDW APIs
simply don't cover issuance of DDL.  If you don't like dblink, you
could consider writing code within plperlu or plpythonu or another
"untrusted" PL, making use of whatever Postgres client library exists
within that PL's ecosystem to connect to the remote server.  It's also
possible that there's some third-party extension that overlaps
dblink's functionality.  dblink sure seems like the path of least
resistance, though.

			regards, tom lane

view thread (2+ messages)  latest in thread

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], [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