Postgresql List foreign data wrappers?

Question

This explains how to create a foreign data wrapper.

So how to list all the existing foreign data wrappers ?

Denis de Bernardy · Accepted Answer · 2014-11-27 11:02:38Z

12

Many FDWs are listed in the Postgres Wiki:

psql has useful commands as well to know which FDWs are defined, e.g. \dew[+]:

answered Nov 27, 2014 at 11:02

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

This is very useful. Is there a way to list the foreign tables and servers in fdw context.

@Viraj: presumably. Use psql -E and \dew+ to see the precise queries that target the catalog, and how they're stored in it.

Jaqo · Accepted Answer · 2016-05-31 06:45:10Z

6

Just \det, or \det[+] for more details.

answered May 31, 2016 at 6:45

Jaqo

3491 gold badge5 silver badges15 bronze badges

Reinsbrain · Accepted Answer · 2021-11-03 09:58:38Z

5

SELECT fdwname FROM pg_foreign_data_wrapper;

answered Nov 3, 2021 at 9:58

Reinsbrain

2,6412 gold badges27 silver badges40 bronze badges