Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Postgresql List foreign data wrappers?

Tags:

postgresql

This explains how to create a foreign data wrapper.

So how to list all the existing foreign data wrappers ?

like image 375
Viraj Avatar asked Nov 27 '14 10:11

Viraj


2 Answers

Many FDWs are listed in the Postgres Wiki:

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

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

http://www.postgresql.org/docs/current/static/app-psql.html

like image 133
Denis de Bernardy Avatar answered Nov 18 '22 16:11

Denis de Bernardy


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

See official documentation here.

like image 38
Jaqo Avatar answered Nov 18 '22 17:11

Jaqo