Difference between revisions of "PostgreSQL list installed extensions"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
[[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) | ||
Revision as of 06:03, 25 October 2022
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)
See also
Advertising:
