Database Reference
In-Depth Information
ltree | 1.0
timetravel | 1.0
worker_spi | 1.0
pg_prewarm | 1.0
btree_gist | 1.0
test_shm_mq | 1.0
seg | 1.0
autoinc | 1.0
postgres_fdw | 1.0
chkpass | 1.0
pgcrypto | 1.2
mysql_fdw | 1.0
earthdistance | 1.0
moddatetime | 1.0
citext | 1.0
plpgsql | 1.0
pg_freespacemap | 1.0
tablefunc | 1.0
dblink | 1.1
intarray | 1.0
pgstattuple | 1.2
pg_buffercache | 1.1
tsearch2 | 1.0
lo | 1.0
hstore | 1.3
unaccent | 1.0
btree_gin | 1.0
pg_trgm | 1.1
refint | 1.0
cube | 1.0
test_parser | 1.0
file_fdw | 1.0
plperl | 1.0
(44 rows)
Beside the list of the available extensions, we can retrieve the installed ones using the
\dx
command:
warehouse_db=# \dx
List of installed extensions
Name |Version| Schema | Description
-----------+-------+------------+---------------------------------
adminpack | 1.0 | pg_catalog | administrative functions for
| | | PostgreSQL
