Sample Header Ad - 728x90

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