Difference between revisions of "PostgreSQL list installed extensions"
Jump to navigation
Jump to search
m (Welcome moved page PostgreSQL list extensions to PostgreSQL list installed extensions) |
|||
| (14 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
[[SELECT * FROM pg extension;]] | [[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]] | [[\dx]] | ||
List of installed extensions | List of installed extensions | ||
| − | Name | Version | Schema | Description | + | Name | Version | [[Schema]] | Description |
| − | --------------------+---------+------------+----------------------------------------------------------- | + | --------------------+---------+------------+----------------------------------------------------------- |
| − | pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed | + | [[pg_stat_statements]] | 1.6 | [[public]] | track execution statistics of all SQL statements executed |
| − | plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language | + | [[plpgsql]] | 1.0 | [[pg_catalog]] | PL/pgSQL procedural language |
| − | (2 rows) | + | (2 rows) |
| + | |||
| + | |||
| + | your-db=# \dx | ||
| + | List of installed extensions | ||
| + | Name | Version | Schema | Description | ||
| + | ---------+---------+------------+------------------------------ | ||
| + | [[plpgsql]] | 1.0 | [[pg_catalog]] | PL/pgSQL procedural language | ||
| + | (1 row) | ||
| + | |||
| + | \dx | ||
| + | List of installed extensions | ||
| + | Name | Version | Schema | Description | ||
| + | --------------------+---------+------------+------------------------------------------------------------------------ | ||
| + | pg_stat_statements | 1.11 | public | track planning and 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 == | == See also == | ||
| + | * {{create extension}} | ||
* {{PostgreSQL extensions}} | * {{PostgreSQL extensions}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 15:30, 19 December 2024
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)
your-db=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
\dx
List of installed extensions
Name | Version | Schema | Description
--------------------+---------+------------+------------------------------------------------------------------------
pg_stat_statements | 1.11 | public | track planning and execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
Related[edit]
See also[edit]
Advertising:
