4

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
  • 2,024
  • 19
  • 31

1 Answers1

8

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
  • 2,024
  • 19
  • 31