postgres@[local]:5432:postgres]
SQL> select * from pg_available_extensions;
name | default_version | installed_version | comment
--------------------+-----------------+-------------------+----------------------------------------------------------------------
sslinfo | 1.0 | <NULL> | information about SSL certificates
lo | 1.0 | <NULL> | Large Object maintenance
insert_username | 1.0 | <NULL> | functions for tracking who changed a table
dblink | 1.1 | <NULL> | connect to other PostgreSQL databases from within a database
earthdistance | 1.0 | <NULL> | calculate great-circle distances on the surface of the Earth
pldbgapi | 1.0 | <NULL> | server-side support for debugging PL/pgSQL functions
btree_gist | 1.0 | <NULL> | support for indexing common datatypes in GiST
uuid-ossp | 1.0 | <NULL> | generate universally unique identifiers (UUIDs)
xml2 | 1.0 | <NULL> | XPath querying and XSLT
isn | 1.0 | <NULL> | data types for international product numbering standards
plpython3u | 1.0 | <NULL> | PL/Python3U untrusted procedural language
pgrowlocks | 1.1 | <NULL> | show row-level locking information
file_fdw | 1.0 | <NULL> | foreign-data wrapper for flat file access
dict_int | 1.0 | <NULL> | text search dictionary template for integers
pg_freespacemap | 1.0 | <NULL> | examine the free space map (FSM)
moddatetime | 1.0 | <NULL> | functions for tracking last modification time
refint | 1.0 | <NULL> | functions for implementing referential integrity (obsolete)
autoinc | 1.0 | <NULL> | functions for autoincrementing fields
pg_stat_statements | 1.1 | 1.1 | track execution statistics of all SQL statements executed
pgstattuple | 1.1 | <NULL> | show tuple-level statistics
chkpass | 1.0 | <NULL> | data type for auto-encrypted passwords
plperl | 1.0 | <NULL> | PL/Perl procedural language
fuzzystrmatch | 1.0 | <NULL> | determine similarities and distance between strings
pltclu | 1.0 | <NULL> | PL/TclU untrusted procedural language
test_parser | 1.0 | <NULL> | example of a custom parser for full-text search
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
tablefunc | 1.0 | <NULL> | functions that manipulate whole tables, including crosstab
intagg | 1.0 | <NULL> | integer aggregator and enumerator (obsolete)
timetravel | 1.0 | <NULL> | functions for implementing time travel
pg_buffercache | 1.0 | <NULL> | examine the shared buffer cache
unaccent | 1.0 | <NULL> | text search dictionary that removes accents
pageinspect | 1.1 | <NULL> | inspect the contents of database pages at a low level
cube | 1.0 | <NULL> | data type for multidimensional cubes
tcn | 1.0 | <NULL> | Triggered change notifications
btree_gin | 1.0 | <NULL> | support for indexing common datatypes in GIN
pltcl | 1.0 | <NULL> | PL/Tcl procedural language
dict_xsyn | 1.0 | <NULL> | text search dictionary template for extended synonym processing
pgcrypto | 1.0 | <NULL> | cryptographic functions
pg_trgm | 1.1 | <NULL> | text similarity measurement and index searching based on trigrams
ltree | 1.0 | <NULL> | data type for hierarchical tree-like structures
adminpack | 1.0 | 1.0 | administrative functions for PostgreSQL
seg | 1.0 | <NULL> | data type for representing line segments or floating-point intervals
tsearch2 | 1.0 | <NULL> | compatibility package for pre-8.3 text search functions
hstore | 1.2 | <NULL> | data type for storing sets of (key, value) pairs
plperlu | 1.0 | <NULL> | PL/PerlU untrusted procedural language
postgres_fdw | 1.0 | <NULL> | foreign-data wrapper for remote PostgreSQL servers
citext | 1.0 | <NULL> | data type for case-insensitive character strings
intarray | 1.0 | <NULL> | functions, operators, and index support for 1-D arrays of integers
(48 rows)
postgres@[local]:5432:postgres]
SQL> select * from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------------------+----------+--------------+----------------+------------+-----------+--------------
plpgsql | 10 | 11 | f | 1.0 | <NULL> | <NULL>
adminpack | 10 | 11 | f | 1.0 | <NULL> | <NULL>
pg_stat_statements | 10 | 2200 | t | 1.1 | <NULL> | <NULL>
(3 rows)
postgres@[local]:5432:postgres]
SQL> \dx
List of installed extensions
Name | Version | Schema | Description
--------------------+---------+------------+-----------------------------------------------------------
adminpack | 1.0 | pg_catalog | administrative functions for PostgreSQL
pg_stat_statements | 1.1 | public | track execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(3 rows)
postgres@[local]:5432:postgres]
SQL>