List PostgreSQL extensions per database
5
votes
2
answers
2356
views
I have a Postgres 9.5 server with 30 databases.
I would like to find out which database uses which extension(s) in one go, preferably in a query that is usable in pgAdmin.
I know that
* FROM pg_extension
gives me the extensions for the database I am connected to.
I also know that * FROM pg_available_extensions
lists, well, all available extensions.
I also know that * FROM pg_database
lists all existing databases.
**Question**
How can I create a list that includes the database name and the extensions used in each database?
Asked by copossum
(151 rep)
May 17, 2021, 07:36 AM
Last activity: Aug 1, 2025, 04:08 PM
Last activity: Aug 1, 2025, 04:08 PM