PostgreSQL list installed extensions

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

• PostgreSQL, PostgreSQL extensions, CREATE EXTENSION, List extensions (\dx)