postgresql 使用 psql 如何列出安装在数据库中的扩展？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21799956/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Using psql how do I list extensions installed in a database?
提问by ARV
How do I list all extensions that are already installed in a database or schema from psql?
如何从 psql 列出已安装在数据库或架构中的所有扩展？
See also
也可以看看
回答by a_horse_with_no_name
In psql that would be
在 psql 中，这将是
\dx
See the manual for details: http://www.postgresql.org/docs/current/static/app-psql.html
有关详细信息，请参阅手册：http: //www.postgresql.org/docs/current/static/app-psql.html
Doing it in plain SQL it would be a select on pg_extension:
用普通的 SQL 做它会是一个选择pg_extension：
SELECT *
FROM pg_extension
http://www.postgresql.org/docs/current/static/catalog-pg-extension.html
http://www.postgresql.org/docs/current/static/catalog-pg-extension.html
回答by Dave Glassborow
Additionally if you want to know which extensions are available on your server: SELECT * FROM pg_available_extensions
此外，如果您想知道您的服务器上有哪些扩展可用： SELECT * FROM pg_available_extensions
回答by hit3k
This SQL query gives output similar to \dx:
此 SQL 查询提供类似于\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;
Thanks to https://blog.dbi-services.com/listing-the-extensions-available-in-postgresql/
感谢https://blog.dbi-services.com/listing-the-extensions-available-in-postgresql/
