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 1qt8uk-00B0kw-CU for pgsql-general@arkaria.postgresql.org; Wed, 18 Oct 2023 15:56:54 +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 1qt8uh-005k5z-V5 for pgsql-general@arkaria.postgresql.org; Wed, 18 Oct 2023 15:56:52 +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 1qt8uh-005k5Q-G1 for pgsql-general@lists.postgresql.org; Wed, 18 Oct 2023 15:56:52 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qt8ue-001O7Z-4C for pgsql-general@lists.postgresql.org; Wed, 18 Oct 2023 15:56:51 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-9b2f73e3af3so1078348666b.3 for ; Wed, 18 Oct 2023 08:56:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1697644608; x=1698249408; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=DgIL+RYveg9AgN8zkv07YP5W8jmpvgNRm4FTb9md0ik=; b=PoLvLzEAtSdoSAUl4VK2vZoyGSpPVJLY3ft7647UTzWcQ7z1g4xZzkAQunGKOHpGjD Oy1qXPG7kC6d6TYExDYQ9qGlZ3Vbb3pmfytAqm3fzRCHFfN7pMzOTgs22jpNzRI0Asn4 f9ZDkDXn5fITZyTecdJATfpA1M05jhJK2kA2Bek+HeM7zCcUoI8mVSEK2Q5iCLE8fqsH 7Kr/jvgdhpsiM9/KRkQFr0utrcRu3nG38W8oA2TGWHh6JiJeTsFa3OSC2vTifmnAT2Q+ XRGXSoqwZGQCEVffwv9Qnim9xdsW1obTnR9Qy+c8EPLaI11rNxHIjWgBoczMYISZJB7u Rs5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697644608; x=1698249408; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=DgIL+RYveg9AgN8zkv07YP5W8jmpvgNRm4FTb9md0ik=; b=gogEf8/m6AwmOF9dkuc+IUNzjx/QC0tYmPlLonVbPQs25hPoL/NbzEwPvWfsPiQ4Iq w2xNsTy6Uk7EOaxDxaKKe6jThlO2jInQkgUwVlz5F83nFdrg5sT7uR6wB/Luk+SgDTFy hmr3LfUhjRmGINvwwnrA1JZ0Kx0XZe5XaHN+WXHfTLMnhnppb2zMxVreiJ6xBhupOdQx W/+nFh8SzlDRsoNDTkoZVSItazF3tiCmvMg5GM+bN7H0FP7pmrtu19YuGbHR09aCvec+ snVCOyvZqSH95plssD+RBFbqRsqSfW4WLfRR5nIGlWx1RyGsyYnPVVNqMRVCxq5YwaWT Romw== X-Gm-Message-State: AOJu0Yy1SbDoKI7itt5dNODtu54ZY8knFLP6nen7QwFLloVRbwgnU78Z D81KwtMSbYA5AIjyWm5EZnSD+Bg3Jg2jYHh+a4g= X-Google-Smtp-Source: AGHT+IGY6Mex9WBBqWK09JtxuygsXXMry/q804zRRqsaa4TezJ6fxQsuy/ZsrTC75zvVLqkcQqQMjQ== X-Received: by 2002:a17:907:3f1c:b0:9ae:4878:1172 with SMTP id hq28-20020a1709073f1c00b009ae48781172mr4844038ejc.7.1697644607222; Wed, 18 Oct 2023 08:56:47 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:5123:586b:5da6:49f1:3286]) by smtp.gmail.com with ESMTPSA id md23-20020a170906ae9700b009ad87fd4e65sm1920155ejb.108.2023.10.18.08.56.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Oct 2023 08:56:46 -0700 (PDT) Message-ID: <4e7b5deef8b8e5e603bcb9dc32fc20e84bb95419.camel@cybertec.at> Subject: Re: A few questions about foreign tables From: Laurenz Albe To: Marcin Borkowski , pgsql-general@lists.postgresql.org Date: Wed, 18 Oct 2023 17:56:45 +0200 In-Reply-To: <87bkcws5i3.fsf@mbork.pl> References: <87bkcws5i3.fsf@mbork.pl> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-10-18 at 10:24 +0200, Marcin Borkowski wrote: > How to revert the effect of "import foreign schema"?=C2=A0 Is just droppi= ng > 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+ > (May I ask to be cc'd since I'm not subscribed to the list?) But please reply to the list. Yours, Laurenz Albe