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 ) id 1u0KPX-00GcZK-Kz for pgsql-admin@arkaria.postgresql.org; Thu, 03 Apr 2025 13:15:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u0KPV-0079qK-Ox for pgsql-admin@arkaria.postgresql.org; Thu, 03 Apr 2025 13:15:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u0KPV-0079qB-DQ for pgsql-admin@lists.postgresql.org; Thu, 03 Apr 2025 13:15:09 +0000 Received: from jakobs.com ([85.214.83.89] helo=plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u0KPT-003A6X-0z for pgsql-admin@lists.postgresql.org; Thu, 03 Apr 2025 13:15:09 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 33FA9380CBC; Thu, 3 Apr 2025 15:15:06 +0200 (CEST) Received: from plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id S6p6XmNy-IE7; Thu, 3 Apr 2025 15:15:02 +0200 (CEST) Received: from [192.168.178.86] (xdsl-78-35-205-162.nc.de [78.35.205.162]) by rs.plausibolo.de (Postfix) with ESMTPSA id 82C58380C33; Thu, 3 Apr 2025 15:14:57 +0200 (CEST) Message-ID: <716d3afd-77a9-419c-8779-238c24139fd9@jakobs.com> Date: Thu, 3 Apr 2025 15:14:57 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Create foreign table documentation To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 03.04.25 um 15:09 schrieb Mauricio Fernandez: > Hi admins > > Dealing with extension oracle_fdw there are a couple of objects need > to create SERVER, FOREIGN DATA WRAPPER , USER MAPPING , FOREIGN TABLE, > all having clause OPTIONS ( option 'value' [, ...] ), but I can't find > any documentation about it, which are the specific options allowed for > option 'value' in each instruction....: > > Thank you very much in advance > > kind regards > > Mauricio Fernández These options depend on the specific FDW, so you have to look them up in their description. -- Holger Jakobs