Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to check whether the postgres_fdw extension is installed in postgres [duplicate]

Tags:

postgresql

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?

like image 536
qartal Avatar asked Oct 20 '25 17:10

qartal


1 Answers

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.

like image 192
qartal Avatar answered Oct 23 '25 07:10

qartal