Re: PL/pgSQL function to run DDL on a remote server/cluster? - Mailing list pgsql-admin

From Sbob
Subject Re: PL/pgSQL function to run DDL on a remote server/cluster?
Date
Msg-id f06c6ea6-883a-966e-0ba3-ba4026f3a7ac@quadratum-braccas.com
Whole thread Raw
In response to Re: PL/pgSQL function to run DDL on a remote server/cluster?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
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@cybertec.at> 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!






pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: PL/pgSQL function to run DDL on a remote server/cluster?
Next
From: Matt Gibbins
Date:
Subject: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale