Difference between revisions of "PostgreSQL list extensions"

From wikieduonline
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)
  
[[SELECT * FROM pg extension;]]
 
  
 +
[[\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}}
  
{{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: