Difference between revisions of "PostgreSQL list extensions"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 12: Line 12:
 
         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)
  
 
== Related ==
 
== Related ==
* [[\dx]]
+
* <code>[[CREATE EXTENSION]]</code>
 
 
  
 
== See also ==
 
== See also ==

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: