Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Feature Matrix

This table outlines which features were added in which version. To get more information about a feature, click the link or hover the mouse pointer over the text.

Sections


Backend 7.48.08.18.28.38.4
Advisory locksNoNoNoYesYesYes
Autovacuum enabled by defaultNoNoNoNoYesYes
COPY with arbitrary SELECT NoNoNoYesYesYes
CSV support for COPYNoYesYesYesYesYes
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)NoYesYesYesYesYes
Column level permissionsNoNoNoNoNoYes
Common Table Expressions (WITH RECURSIVE)NoNoNoNoNoYes
Concurrent GiST indexesNoNoYesYesYesYes
Crash-safe GiST indexesNoNoYesYesYesYes
DROP object IF EXISTSNoNoNoYesYesYes
Disk based FSMNoNoNoNoNoYes
Dollar QuotingNoYesYesYesYesYes
Holdable cursorsYesYesYesYesYesYes
INSERT/UPDATE/DELETE RETURNINGNoNoNoYesYesYes
Integrated autovacuum daemonNoNoYesYesYesYes
Loadable plugin infrastructure for monitoring the plannerNoNoNoNoYesYes
MVCC safe CLUSTERNoNoNoNoYesYes
Multiple autovacuum workers NoNoNoNoYesYes
Multiple input aggregatesNoNoNoYesYesYes
Multirow VALUESNoNoNoYesYesYes
ON COMMIT clause for CREATE TEMPORARY TABLEYesYesYesYesYesYes
ORDER BY NULLS FIRST/LASTNoNoNoNoYesYes
Point-in-Time RecoveryNoYesYesYesYesYes
Row-wise comparisonNoNoNoYesYesYes
SQL standard interval handlingNoNoNoNoNoYes
SQL-standard information schemaYesYesYesYesYesYes
SavepointsNoYesYesYesYesYes
TABLE statementNoNoNoNoNoYes
Temporary VIEWsNoNoYesYesYesYes
Two Phase commitNoNoYesYesYesYes
Txid functionsNoNoNoNoYesYes
UNNEST/array_aggNoNoNoNoNoYes
Updateable cursorsNoNoNoNoYesYes
Version aware psqlNoNoNoNoNoYes
Visibility mapNoNoNoNoNoYes
WAL-safe B-Tree IndexesYesYesYesYesYesYes
Warm StandbyNoNoNoYesYesYes
Window functionsNoNoNoNoNoYes
Performance 7.48.08.18.28.38.4
Asynchronous CommitNoNoNoNoYesYes
Automatic plan invalidationNoNoNoNoYesYes
Background WriterNoYesYesYesYesYes
Cross datatype hashing supportNoNoNoNoYesYes
Distributed checkpointingNoNoNoNoYesYes
Full Text SearchNoNoNoNoYesYes
GIN (Generalized Inverted Index) IndexesNoNoNoYesYesYes
GIN indexes partial matchNoNoNoNoNoYes
GiST (Generalized Search Tree) IndexesYesYesYesYesYesYes
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPTNoNoNoNoNoYes
Hashing support for NUMERIC NoNoNoNoYesYes
Heap Only Tuples (HOT)NoNoNoNoYesYes
In-memory Bitmap IndexesNoNoYesYesYesYes
Index support for IS NULLNoNoNoNoYesYes
Indexes on expressionsYesYesYesYesYesYes
Inlining of SQL-functionsYesYesYesYesYesYes
Lazy XID allocationNoNoNoNoYesYes
Multiple temporary tablespacesNoNoNoNoYesYes
Non-blocking CREATE INDEXNoNoNoYesYesYes
Outer Join reorderingNoNoNoYesYesYes
Parallel restoreNoNoNoNoNoYes
Partial sort capability (top-n sorting)NoNoNoNoYesYes
SELECT ... FOR UPDATE/SHARE NOWAITNoNoYesYesYesYes
Semi- and AntijoinsNoNoNoNoNoYes
Shared row level lockingNoNoYesYesYesYes
Synchronized sequential scanningNoNoNoNoYesYes
Table partitioningNoNoYesYesYesYes
TablespacesNoYesYesYesYesYes
Security 7.48.08.18.28.38.4
GSSAPI supportNoNoNoNoYesYes
Native LDAP authenticationNoNoNoYesYesYes
Per user/database connection limitsNoNoYesYesYesYes
ROLESNoNoYesYesYesYes
SSL certificate validation in libpqNoNoNoNoNoYes
SSL client certificate authenticationNoNoNoNoNoYes
Security Service Provider Interface (SSPI)NoNoNoNoYesYes
Network 7.48.08.18.28.38.4
Full SSL supportYesYesYesYesYesYes
IPv6 SupportYesYesYesYesYesYes
V2 client protocolYesYesYesYesYesYes
V3 client protocolYesYesYesYesYesYes
Internationalisation 7.48.08.18.28.38.4
Database level CollationNoNoNoNoNoYes
EUC_JIS_2004/ SHIFT_JIS_2004 supportNoNoNoNoYesYes
Multibyte encoding support, incl. UTF8YesYesYesYesYesYes
Multiple language supportYesYesYesYesYesYes
UTF8 support on WindowsNoNoYesYesYesYes
Unicode string literals and identifiersNoNoNoNoNoYes
Platforms 7.48.08.18.28.38.4
Microsoft Visual C++ SupportNoNoNoNoYesYes
Native Windows PortNoYesYesYesYesYes
Sun Studio compiler on LinuxNoNoNoNoNoYes
Datatypes 7.48.08.18.28.38.4
Array supportYesYesYesYesYesYes
Arrays of compound typesNoNoNoNoYesYes
ENUM data typeNoNoNoNoYesYes
GUID/UUID data typeNoNoNoNoYesYes
IS0 8601 interval syntaxNoNoNoNoNoYes
NULLs in ArrayNoNoNoYesYesYes
Type modifier supportNoNoNoNoYesYes
XML data typeNoNoNoNoYesYes
Functions and triggers 7.48.08.18.28.38.4
ALTER TABLE / ENABLE REPLICA TRIGGER/RULENoNoNoNoYesYes
ALTER TABLE ENABLE/DISABLE TRIGGERNoNoYesYesYesYes
Per function statisticsNoNoNoNoNoYes
Per-function GUC settingsNoNoNoNoYesYes
RETURN QUERY EXECUTENoNoNoNoNoYes
RETURNS TABLENoNoNoNoNoYes
Statement level TRUNCATE triggersNoNoNoNoNoYes
Statement level triggersYesYesYesYesYesYes
Variadic functionsNoNoNoNoNoYes
Procedural Languages 7.48.08.18.28.38.4
CASE in pl/pgsqlNoNoNoNoNoYes
CONTINUE statement for PL/pgSQLNoNoYesYesYesYes
EXCEPTION support in PL/pgSQLNoYesYesYesYesYes
EXECUTE USING in PL/pgSQLNoNoNoNoNoYes
IN/OUT/INOUT parameters for pl/pgsql and PL/SQLNoNoYesYesYesYes
Named parametersNoYesYesYesYesYes
Non-superuser language creationNoNoNoNoYesYes
Number of function arguments increased to 100NoNoYesYesYesYes
Polymorphic functionsYesYesYesYesYesYes
Qualified function parameters NoNoNoNoYesYes
RETURN QUERY in pl/pgsqlNoNoNoNoYesYes
ROWS and COST specification for functionsNoNoNoNoYesYes
SQLERRM/SQLSTATE for pl/pgsqlNoNoYesYesYesYes
Scrollable and updatable cursor support for pl/pgsqlNoNoNoNoYesYes
User defined exceptionsNoNoNoNoNoYes
Validator function for pl/perlNoNoYesYesYesYes
contrib modules 7.48.08.18.28.38.4
contrib/adminpackNoNoNoYesYesYes
contrib/autoexplainNoNoNoNoNoYes
contrib/btree_ginNoNoNoNoNoYes
contrib/btree_gistNoYesYesYesYesYes
contrib/citextNoNoNoNoNoYes
contrib/dblinkYesYesYesYesYesYes
contrib/dbsizeYesYesObsoleteObsoleteObsoleteObsolete
contrib/fuzzystrmatchYesYesYesYesYesYes
contrib/hstoreNoNoNoYesYesYes
contrib/intarrayYesYesYesYesYesObsolete
contrib/isn (ISBN)NoNoNoYesYesYes
contrib/ltreeYesYesYesYesYesYes
contrib/pageinspectNoNoNoNoYesYes
contrib/pg_autovacuumYesYesObsoleteObsoleteObsoleteObsolete
contrib/pg_buffercacheNoNoYesYesYesYes
contrib/pg_freespacemapNoNoNoYesYesYes
contrib/pg_standbyNoNoNoNoYesYes
contrib/pg_stat_statementsNoNoNoNoNoYes
contrib/pg_trgmNoYesYesYesYesYes
contrib/pgbenchYesYesYesYesYesYes
contrib/pgstattupleYesYesYesYesYesYes
contrib/segYesYesYesYesYesYes
contrib/sslinfoNoNoNoYesYesYes
contrib/tablefuncYesYesYesYesYesYes
contrib/tsearch2YesYesYesYesObsoleteObsolete
contrib/tsearch2 UTF8 supportNoNoNoYesObsoleteObsolete
contrib/tsearch2 compat wrapperNoNoNoNoYesYes
contrib/userlocksYesYesYesObsoleteObsoleteObsolete
contrib/uuid-osspNoNoNoNoYesYes
contrib/xml2NoYesYesYesYesObsolete

If you are a contributor, click here to edit the contents of this page.


Privacy Policy | Project hosted by our server sponsors. | Designed by tinysofa
Copyright © 1996 – 2009 PostgreSQL Global Development Group