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
