↑↓ select ↵ open ⌫ change scope Open full search

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

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index31
PostgreSQL 10VersionsWikiVersions · PostgreSQL 10End of life; recorded build 10.23. 24 release notes with 1140 original entries. First release 2017-10-05; end of life 2022-11-10. 10.0 Hash indexes must be rebuilt after pg_upgrade-ing from … PostgreSQL 11VersionsWikiVersions · PostgreSQL 11End of life; recorded build 11.22. 23 release notes with 1141 original entries. First release 2018-10-18; end of life 2023-11-09. 11.0 Make pg_dump dump the properties of a database, not jus… PostgreSQL 12VersionsWikiVersions · PostgreSQL 12End of life; recorded build 12.22. 23 release notes with 1181 original entries. First release 2019-10-03; end of life 2024-11-21. 12.0 Remove the special behavior of oid columns (Andres Freu… PostgreSQL 13VersionsWikiVersions · PostgreSQL 13End of life; recorded build 13.23. 24 release notes with 1164 original entries. First release 2020-09-24; end of life 2025-11-13. 13.0 Change SIMILAR TO ... ESCAPE NULL to return NULL (Tom L… PostgreSQL 14VersionsWikiVersions · PostgreSQL 14Supported; recorded build 14.24. 25 release notes with 1206 original entries. First release 2021-09-30; end of life 2026-11-12. 14.0 User-defined objects that reference certain built-in arra… PostgreSQL 15VersionsWikiVersions · PostgreSQL 15Supported; recorded build 15.19. 20 release notes with 1046 original entries. First release 2022-10-13; end of life 2027-11-11. 15.0 Remove PUBLIC creation permission on the public schema (N… PostgreSQL 16VersionsWikiVersions · PostgreSQL 16Supported; recorded build 16.15. 16 release notes with 930 original entries. First release 2023-09-14; end of life 2028-11-09. 16.0 Change assignment rules for PL/pgSQL bound cursor variable… PostgreSQL 17VersionsWikiVersions · PostgreSQL 17Supported; recorded build 17.11. 12 release notes with 727 original entries. First release 2024-09-26; end of life 2029-11-08. 17.0 Change functions to use a safe search_path during maintena… PostgreSQL 18VersionsWikiVersions · PostgreSQL 18Current stable; recorded build 18.6. 6 release notes with 561 original entries. First release 2025-09-25; end of life 2030-11-14. 18.0 Change initdb default to enable data checksums (Greg Sa… PostgreSQL 19VersionsWikiVersions · PostgreSQL 19Preview; recorded build 19beta4. 1 release notes with 198 original entries. 19beta4 Add server variable password_expiration_warning_threshold to warn about password expiration (Gilles Darold… PostgreSQL 20VersionsWikiVersions · PostgreSQL 20Development; recorded build 20devel. 0 release notes with 0 original entries. PostgreSQL 6.3VersionsWikiVersions · PostgreSQL 6.3End of life; recorded build 6.3.2. 0 release notes with 0 original entries. First release 1998-03-01; end of life 2003-03-01. PostgreSQL 6.4VersionsWikiVersions · PostgreSQL 6.4End of life; recorded build 6.4.2. 0 release notes with 0 original entries. First release 1998-10-30; end of life 2003-10-30. PostgreSQL 6.5VersionsWikiVersions · PostgreSQL 6.5End of life; recorded build 6.5.3. 0 release notes with 0 original entries. First release 1999-06-09; end of life 2004-06-09. PostgreSQL 7.0VersionsWikiVersions · PostgreSQL 7.0End of life; recorded build 7.0.3. 0 release notes with 0 original entries. First release 2000-05-08; end of life 2005-05-08. PostgreSQL 7.1VersionsWikiVersions · PostgreSQL 7.1End of life; recorded build 7.1.3. 0 release notes with 0 original entries. First release 2001-04-13; end of life 2006-04-13. PostgreSQL 7.2VersionsWikiVersions · PostgreSQL 7.2End of life; recorded build 7.2.8. 0 release notes with 0 original entries. First release 2002-02-04; end of life 2007-02-04. PostgreSQL 7.3VersionsWikiVersions · PostgreSQL 7.3End of life; recorded build 7.3.21. 0 release notes with 0 original entries. First release 2002-11-27; end of life 2007-11-27. PostgreSQL 7.4VersionsWikiVersions · PostgreSQL 7.4End of life; recorded build 7.4.30. 0 release notes with 0 original entries. First release 2003-11-17; end of life 2010-10-01. PostgreSQL 8.0VersionsWikiVersions · PostgreSQL 8.0End of life; recorded build 8.0.26. 0 release notes with 0 original entries. First release 2005-01-19; end of life 2010-10-01. PostgreSQL 8.1VersionsWikiVersions · PostgreSQL 8.1End of life; recorded build 8.1.23. 0 release notes with 0 original entries. First release 2005-11-08; end of life 2010-11-08. PostgreSQL 8.2VersionsWikiVersions · PostgreSQL 8.2End of life; recorded build 8.2.23. 0 release notes with 0 original entries. First release 2006-12-05; end of life 2011-12-05. PostgreSQL 8.3VersionsWikiVersions · PostgreSQL 8.3End of life; recorded build 8.3.23. 0 release notes with 0 original entries. First release 2008-02-04; end of life 2013-02-07. PostgreSQL 8.4VersionsWikiVersions · PostgreSQL 8.4End of life; recorded build 8.4.22. 0 release notes with 0 original entries. First release 2009-07-01; end of life 2014-07-24. PostgreSQL 9.0VersionsWikiVersions · PostgreSQL 9.0End of life; recorded build 9.0.23. 24 release notes with 850 original entries. First release 2010-09-20; end of life 2015-10-08. 9.0.0 Remove server parameter add_missing_from, which was de… PostgreSQL 9.1VersionsWikiVersions · PostgreSQL 9.1End of life; recorded build 9.1.24. 25 release notes with 895 original entries. First release 2011-09-12; end of life 2016-10-27. 9.1.0 Change the default value of standard_conforming_string… PostgreSQL 9.2VersionsWikiVersions · PostgreSQL 9.2End of life; recorded build 9.2.24. 25 release notes with 968 original entries. First release 2012-09-10; end of life 2017-11-09. 9.2.0 Remove the spclocation field from pg_tablespace (Magnu… PostgreSQL 9.3VersionsWikiVersions · PostgreSQL 9.3End of life; recorded build 9.3.25. 26 release notes with 968 original entries. First release 2013-09-09; end of life 2018-11-08. 9.3.0 Rename replication_timeout to wal_sender_timeout (Amit… PostgreSQL 9.4VersionsWikiVersions · PostgreSQL 9.4End of life; recorded build 9.4.26. 27 release notes with 1007 original entries. First release 2014-12-18; end of life 2020-02-13. 9.4.0 Tighten checks for multidimensional array input (Bruc… PostgreSQL 9.5VersionsWikiVersions · PostgreSQL 9.5End of life; recorded build 9.5.25. 26 release notes with 1026 original entries. First release 2016-01-07; end of life 2021-02-11. 9.5.0 Adjust operator precedence to match the SQL standard … PostgreSQL 9.6VersionsWikiVersions · PostgreSQL 9.6End of life; recorded build 9.6.24. 25 release notes with 1105 original entries. First release 2016-09-29; end of life 2021-11-11. 9.6.0 Improve the pg_stat_activity view's information about…

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open