Database Reference
In-Depth Information
btree_gin | 1.0 | public | support for indexing common data
| | | types in GIN
chkpass | 1.0 | public | data type for auto-encrypted
| | | passwords
citext | 1.0 | public | data type for case-insensitive
| | | character strings
cube | 1.0 | public | data type for multidimensional
| | | cubes
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(6 rows)
Additional supplied extensions
In the default installation of PostgreSQL, there are some other extensions available
on the system and they can be created using the
CREATE EXTENSION
command.
Here is a complete list with some information about all available extensions. There
are many extensions available and listing them here is out of the scope of this topic,
but you can get the list of all available extensions using these SQL commands:
warehouse_db=# SELECT name, comment FROM
pg_available_extension_versions;
name | comment
--------------------+---------------------------------------------
pageinspect | inspect the contents of database pages at a
| low level
tcn | triggered change notifications
pg_stat_statements | track execution statistics of all SQL
| statements executed
adminpack | administrative functions for PostgreSQL
pgrowlocks | show row-level locking information
dict_int | text search dictionary template for integers
isn | data types for international product
| numbering standards
mongo_fdw | foreign data wrapper for MongoDB access
dict_xsyn | text search dictionary template for extended
| synonym processing
fuzzystrmatch | determine similarities and distance between
| strings
insert_username | functions for tracking who changed a table
intagg | integer aggregator and enumerator (obsolete)
ltree | data type for hierarchical tree-like
| structures
timetravel | functions for implementing time travel
worker_spi | sample background worker
