| Query goal: | Find extensions that routines are in the schema public. |
| Query type: | General (Overview of some aspect of the database.) |
| Query license: | MIT License |
| Data source: | system catalog only |
| SQL query: | Click on query to copy it
SELECT DISTINCT e.extname AS extension_name, e.extversion AS extension_version FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n, pg_catalog.pg_depend d, pg_catalog.pg_extension e WHERE p.pronamespace = n.oid AND p.oid=d.objid AND e.oid=d.refobjid AND n.nspname='public' ORDER BY extension_name; |
| Collection name | Collection description |
|---|---|
| Find problems automatically | Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not . |
| Category name | Category description |
|---|---|
| Extensions | Queries of this category provide information about extensions in the database. |