On 3/23/23 14:16, Laurenz Albe wrote:
On Thu, 2023-03-23 at 15:15 -0400, Tom Lane wrote:
Laurenz Albe <laurenz.albe@xxxxxxxxxxx> writes:
On Thu, 2023-03-23 at 12:03 -0600, Sbob wrote:
Is it possible to execute DDL on a remote server/cluster from a PL/pgSQL
function?
If so can someone point me to docs or an example?
You cannot do that with the built-in tools.
You'd have to write an extension that can do that.
You do need an extension, but contrib/dblink should do fine.
Ah, of course. Silly of me.
Yours,
Laurenz Albe
Thanks Tom!
