Re: A few questions about foreign tables - Mailing list pgsql-general

From Laurenz Albe
Subject Re: A few questions about foreign tables
Date
Msg-id 4e7b5deef8b8e5e603bcb9dc32fc20e84bb95419.camel@cybertec.at
Whole thread Raw
In response to A few questions about foreign tables  (Marcin Borkowski <mbork@mbork.pl>)
Responses Re: A few questions about foreign tables  (Ron <ronljohnsonjr@gmail.com>)
Re: A few questions about foreign tables  (Marcin Borkowski <mbork@mbork.pl>)
List pgsql-general
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+ <table name>

> (May I ask to be cc'd since I'm not subscribed to the list?)

But please reply to the list.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: postgres keeps having blocks
Next
From: Ron
Date:
Subject: Re: A few questions about foreign tables