PostgreSQL 11 Administration Cookbook

How to do it…

In PostgreSQL, there is a catalog table recording the list of installed extensions, so this recipe is quite simple. Issue the following command:

cookbook=> SELECT * FROM pg_extension;

This results in the following output:

Note that the format is expanded, as if the \x meta command has been previously issued.

-[ RECORD 1 ]--+--------extname        | plpgsqlextowner       | 10extnamespace   | 11extrelocatable | fextversion     | 1.0extconfig      |extcondition   |

To get the same list with fewer technical details, you can use the \dx meta command, as when listing databases.