Difference between revisions of "PostgreSQL list installed extensions"

From wikieduonline
Jump to navigation Jump to search
Line 5: Line 5:
  
 
  [[\dx]]
 
  [[\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)
  
  

Revision as of 06:02, 25 October 2022


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)


See also

Advertising: