Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1snOnz-003Dxn-8b
	for pgsql-general@arkaria.postgresql.org; Sun, 08 Sep 2024 20:46:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1snOny-0015hX-5F
	for pgsql-general@arkaria.postgresql.org; Sun, 08 Sep 2024 20:46:42 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1snOnw-0015f0-HD
	for pgsql-general@lists.postgresql.org; Sun, 08 Sep 2024 20:46:41 +0000
Received: from fhigh1-smtp.messagingengine.com ([103.168.172.152])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1snOnt-000BnN-5U
	for pgsql-general@lists.postgresql.org; Sun, 08 Sep 2024 20:46:39 +0000
Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46])
	by mailfhigh.phl.internal (Postfix) with ESMTP id 97B59114012D;
	Sun,  8 Sep 2024 16:46:35 -0400 (EDT)
Received: from phl-mailfrontend-02 ([10.202.2.163])
  by phl-compute-06.internal (MEProxy); Sun, 08 Sep 2024 16:46:35 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm3; t=1725828395;
	 x=1725914795; bh=xUYXd3VaKN+ryJvJtWuH5lPRCWdeFljmCzBg8kVGS9U=; b=
	hb33P2SnimSZ0hO+inCvhEYVGA9Bvh8FgvA3NnTDP1noA2X/W+Ft1OlAYPRY/Vgl
	I5dga8pp25S93JtphI5IHzyBG70i7O8ktnniYfHbcdFH6ATMH0Yjf+6dGbPnxWrJ
	M7qvwAZnx47NG5efrw7SwzEOH+3FxM9GzKGMa6apmhvuyT7+qeR/hPB9v6Fu3bLM
	aebWLyCRu02c1X0472ncwypbotg9n3+ozwCeiw57aQskza5VqWBcMu/OK+0Rm9Es
	PJpDnrS6VnghugFuhcFl4SE/6BscOyX5TqGwvIBraXcFbEfxw4xckjfaiYybCmZw
	/OkGoCF1T53UUXGAExw5tw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1725828395; x=
	1725914795; bh=xUYXd3VaKN+ryJvJtWuH5lPRCWdeFljmCzBg8kVGS9U=; b=p
	m0NudEfYwwE22b4qvAe6+hGaUo9+WUbvj2WniRGflaC8/eculS2HW7xbz0884NmL
	agABupVnNmR7OkH6KjFtl46w5WIQnNA1amivAG2GIFAWc3bCy6kk1Khcj3UByZ5M
	iPJS6RYZsqYORiPb9D8p51xMiP4dWyWNe4gTeVWYZu4iZxuufahX1ez4WGq6wibf
	FbC8V1P0HOS0jfz0uGaGMyZSaXNnY2D11ULkD7iMfZgzXVb0reUYgZxB6M20HcGf
	FA9FuxIWsAdmMF/sl16jBsU8UV9x40pzAo9svaDMpDcemwVo/oizcIo6smPpZ6ff
	n2dNFFF9J7vatPhIWOWpg==
X-ME-Sender: <xms:Kw3eZg5At91ZASnN1jD928ywzrjq2eqAQ6ADf1On4zylWzWgEoXvTw>
    <xme:Kw3eZh72cIPDAVHlGuhOBKCFN_gZ7LWwaLE_70t6bc2vO2pWT3Cz6ldsRXXFpP8PY
    UyVH-X0W76Tzck>
X-ME-Received: <xmr:Kw3eZvcWQFO6DH8RzfDm4S4abIa69Vvs2paxmQ043OlZtGnQHbDgoSPourLym0DeOenX0o4i-CYpst8ON5y4rBy-HO_bNQ>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudeihedgudehgecutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp
    uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg
    hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdej
    necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh
    esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieel
    jeeitedtjeehudegfeelkedvleekhedtgfeiffefkedunecuvehluhhsthgvrhfuihiivg
    eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk
    lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpd
    hrtghpthhtoheprgdrmhgrnhhtiihiohhssegtlhhouhgurdhgrghtvgifrgihnhgvthdr
    tghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsth
    hgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:Kw3eZlIdg6lAATVVz2T8Pmp9XfCFgqsmUcuy1yT4Fjt0P9K3idGR1Q>
    <xmx:Kw3eZkLsBlnwfk29XDCieZWAHbQkd1AomTJzAz1V_GRS_54Jd_OIvw>
    <xmx:Kw3eZmyA9KkTtADNmC_ynWSExQUbFVQ3IuR7gKOqGfRJG0jGnDW28Q>
    <xmx:Kw3eZoJHqYaKkGEmG3RqNnLFqHM8wBNvLu1ExDTL0HVHtE9G2JqZ0w>
    <xmx:Kw3eZrV_9qbAqd_Ms926ZNbx9tDCEZz34zdpBTQV19fZAJfEsp8L6Euj>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun,
 8 Sep 2024 16:46:34 -0400 (EDT)
Message-ID: <f54de1ef-7c11-4289-9075-560d899d1295@aklaver.com>
Date: Sun, 8 Sep 2024 13:46:34 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: postgresql FDW vs dblink for DDL
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <c150aec1-10e1-4004-b71f-6a87efcf8b37@cloud.gatewaynet.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <c150aec1-10e1-4004-b71f-6a87efcf8b37@cloud.gatewaynet.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/f54de1ef-7c11-4289-9075-560d899d1295%40aklaver.com>
Precedence: bulk

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
> 
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com