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 1qtqsb-00EDyW-Im for pgsql-general@arkaria.postgresql.org; Fri, 20 Oct 2023 14:53:37 +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 1qtqaw-002ozX-2K for pgsql-general@arkaria.postgresql.org; Fri, 20 Oct 2023 14:35:22 +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 ) id 1qtkpr-00F80W-Oj for pgsql-general@lists.postgresql.org; Fri, 20 Oct 2023 08:26:24 +0000 Received: from mail.mojserwer.eu ([195.110.48.8]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtkpk-001OEv-V6 for pgsql-general@lists.postgresql.org; Fri, 20 Oct 2023 08:26:23 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.mojserwer.eu (Postfix) with ESMTP id 733A4976D4B; Fri, 20 Oct 2023 10:26:12 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mail.mojserwer.eu Received: from mail.mojserwer.eu ([127.0.0.1]) by localhost (mail.mojserwer.eu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ce5Jo6xZxY9N; Fri, 20 Oct 2023 10:26:09 +0200 (CEST) Received: from localhost (91-227-196-3.net4me.pl [91.227.196.3]) by mail.mojserwer.eu (Postfix) with ESMTPSA id 1C30E22715A4; Fri, 20 Oct 2023 10:26:08 +0200 (CEST) References: <87bkcws5i3.fsf@mbork.pl> <4e7b5deef8b8e5e603bcb9dc32fc20e84bb95419.camel@cybertec.at> User-agent: mu4e 1.1.0; emacs 30.0.50 From: Marcin Borkowski To: Laurenz Albe Cc: pgsql-general@lists.postgresql.org Subject: Re: A few questions about foreign tables In-reply-to: <4e7b5deef8b8e5e603bcb9dc32fc20e84bb95419.camel@cybertec.at> Date: Fri, 20 Oct 2023 10:26:04 +0200 Message-ID: <8734y53dk3.fsf@mbork.pl> MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-10-18, at 17:56, Laurenz Albe wrote: > On Wed, 2023-10-18 at 10:24 +0200, Marcin Borkowski wrote: >> How to revert the effect of "import foreign schema"? Is just dropping >> the imported tables enough? > > Running DROP FOREIGN TABLE ... for all imported tables is enough. > >> Also, how can I check the definitions (i.e., what tables on the server >> they correspond to) of existing foreign tables? > > \d+ Thanks. >> (May I ask to be cc'd since I'm not subscribed to the list?) > > But please reply to the list. Of course. -- Marcin Borkowski http://mbork.pl