用下面语句可以查询：SELECT

e.extname AS "Name",

e.extversion AS "Version",

n.nspname AS "Schema",

C.description AS "Description"

FROM

pg_catalog.pg_extension e

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace

LEFT JOIN pg_catalog.pg_description C ON C.objoid = e.oid

AND C.classoid = 'pg_catalog.pg_extension' :: pg_catalog.regclass

ORDER BY

1;

SELECT

e.extname AS "Name",

e.extversion AS "Version",

n.nspname AS "Schema",

C.description AS "Description"

FROM

pg_catalog.pg_extension e

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace

LEFT JOIN pg_catalog.pg_description C ON C.objoid = e.oid

AND C.classoid = 'pg_catalog.pg_extension' :: pg_catalog.regclass

ORDER BY

1;

是的，\dx就可以查出来安装插件情况

是的，\dx就可以查出来安装插件情况

SELECT

e.extname AS "Name",

e.extversion AS "Version",

n.nspname AS "Schema",

C.description AS "Description"

FROM

pg_catalog.pg_extension e

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace

LEFT JOIN pg_catalog.pg_description C ON C.objoid = e.oid

AND C.classoid = 'pg_catalog.pg_extension' :: pg_catalog.regclass

ORDER BY

1;

SELECT

e.extname AS "Name",

e.extversion AS "Version",

n.nspname AS "Schema",

C.description AS "Description"

FROM

pg_catalog.pg_extension e

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace

LEFT JOIN pg_catalog.pg_description C ON C.objoid = e.oid

AND C.classoid = 'pg_catalog.pg_extension' :: pg_catalog.regclass

ORDER BY

1;