2

I need to use postgres_fdw to link two database. According to this guide, the first step is to install postgres_fdw extension.

How can I check this is already installed on the server or not?

qartal
  • 1,904
  • 16
  • 30

1 Answers1

6

I think I fond how to check it:

select * from pg_extension where extname='postgres_fdw';

pg_extension seems to have the list of installed extensions.

qartal
  • 1,904
  • 16
  • 30