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;
Collections
This query belongs to the following collections:
Name
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 .
Categories
This query is classified under the following categories:
Name
Description
Extensions
Queries of this category provide information about extensions in the database.