select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0
Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.

H.2. Extensions

PostgreSQL was designed from the start to be extensible. For this reason, extensions loaded into the database can function just like features that are packaged with the database. The contrib/ directory shipped with the source code contains a large number of extensions. The README file in that directory contains a summary. They include conversion tools, full-text indexing, XML tools, and additional data types and indexing methods. Other extensions are developed independently, like PostGIS. Even PostgreSQL replication solutions are developed externally. For example, Slony-I is a popular master/slave replication solution that is developed independently from the core project.

There are several administration tools available for PostgreSQL. The most popular is pgAdmin, and there are several commercially available ones.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.