Re: postgresql FDW vs dblink for DDL

2024-09-09 Thread Achilleas Mantzios
Στις 9/9/24 18:40, ο/η Tom Lane έγραψε: Adrian Klaver 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 manipula

Re: postgresql FDW vs dblink for DDL

2024-09-09 Thread Tom Lane
Adrian Klaver 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, >> t

Re: postgresql FDW vs dblink for DDL

2024-09-09 Thread Adrian Klaver
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 instanc

Re: postgresql FDW vs dblink for DDL

2024-09-09 Thread Achilleas Mantzios - cloud
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 com

Re: postgresql FDW vs dblink for DDL

2024-09-08 Thread Adrian Klaver
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. thanks

postgresql FDW vs dblink for DDL

2024-09-08 Thread Achilleas Mantzios
Hi for remote DDL execution (such as CREATE TABLE) is dblink my only option? thanks