t of "import foreign schema"? Is just dropping
the imported tables enough?
Also, how can I check the definitions (i.e., what tables on the server
they correspond to) of existing foreign tables?
(May I ask to be cc'd since I'm not subscribed to the list?)
TIA,
--
Marcin Borkowski
http://mbork.pl
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 t
ROP FOREIGN TABLE IF EXISTS %I.%I RESTRICT;'
> , relnamespace::regnamespace::text, relname)
> FROM pg_class WHERE relkind='f'
> ORDER BY relkind;
Thanks, though happily I only have about a dozen of them, so I could
create these by hand (well, actually by some automation fea
Hello,
I noticed that the docs for postgres_fdw lack the clause about it being
"trusted". Does that mean that `create extension postgres_fdw` poses
any known security risks? If so, what should I do to minimize them?
TIA,
--
Marcin Borkowski
http://mbork.pl
