Difference between revisions of "PostgreSQL list extensions"
Jump to navigation
Jump to search
(Created page with " SELECT * FROM pg extension; {{PostgreSQL extensions}}") |
|||
(13 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | [[SELECT * FROM pg extension;]] | ||
+ | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition | ||
+ | --------------+----------+--------------+----------------+------------+-----------+-------------- | ||
+ | [[plpgsql]] | 10 | 11 | f | 1.0 | | | ||
+ | [[pg_stat_statements]] | 10 | 2200 | t | 1.6 | | | ||
+ | (2 rows) | ||
− | |||
+ | [[\dx]] | ||
+ | List of installed extensions | ||
+ | Name | Version | [[Schema]] | Description | ||
+ | --------------------+---------+------------+----------------------------------------------------------- | ||
+ | [[pg_stat_statements]] | 1.6 | [[public]] | track execution statistics of all SQL statements executed | ||
+ | [[plpgsql]] | 1.0 | [[pg_catalog]] | PL/pgSQL procedural language | ||
+ | (2 rows) | ||
+ | == Related == | ||
+ | * <code>[[CREATE EXTENSION]]</code> | ||
+ | == See also == | ||
+ | * {{PostgreSQL extensions}} | ||
− | + | [[Category:PostgreSQL]] |
Latest revision as of 11:50, 11 May 2023
SELECT * FROM pg extension; extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition --------------+----------+--------------+----------------+------------+-----------+-------------- plpgsql | 10 | 11 | f | 1.0 | | pg_stat_statements | 10 | 2200 | t | 1.6 | | (2 rows)
\dx List of installed extensions Name | Version | Schema | Description --------------------+---------+------------+----------------------------------------------------------- pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (2 rows)
Related[edit]
See also[edit]
Advertising: