Difference between revisions of "PostgreSQL list installed extensions"

From wikieduonline
Jump to navigation Jump to search
Line 20: Line 20:
  
 
== See also ==
 
== See also ==
 +
* {{create extension}}
 
* {{PostgreSQL extensions}}
 
* {{PostgreSQL extensions}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Revision as of 14:57, 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)

Related

See also

Advertising: