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.3
Advisory locksNoNoNoYesYes
Autovacuum enabled by defaultNoNoNoNoYes
COPY with arbitrary SELECT NoNoNoYesYes
CSV support for COPYNoYesYesYesYes
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)NoYesYesYesYes
Concurrent GiST indexesNoNoYesYesYes
Crash-safe GiST indexesNoNoYesYesYes
DROP object IF EXISTSNoNoNoYesYes
Dollar QuotingNoYesYesYesYes
Holdable cursorsYesYesYesYesYes
INSERT/UPDATE/DELETE RETURNINGNoNoNoYesYes
Integrated autovacuum daemonNoNoYesYesYes
Loadable plugin infrastructure for monitoring the plannerNoNoNoNoYes
MVCC safe CLUSTERNoNoNoNoYes
Multiple autovacuum workers NoNoNoNoYes
Multiple input aggregatesNoNoNoYesYes
Multirow VALUESNoNoNoYesYes
ON COMMIT clause for CREATE TEMPORARY TABLEYesYesYesYesYes
ORDER BY NULLS FIRST/LASTNoNoNoNoYes
Point-in-Time RecoveryNoYesYesYesYes
Row-wise comparisonNoNoNoYesYes
SQL-standard information schemaYesYesYesYesYes
SavepointsNoYesYesYesYes
Temporary VIEWsNoNoYesYesYes
Two Phase commitNoNoYesYesYes
Txid functionsNoNoNoNoYes
Updateable cursorsNoNoNoNoYes
WAL-safe B-Tree IndexesYesYesYesYesYes
Warm StandbyNoNoNoYesYes
Performance 7.48.08.18.28.3
Asynchronous CommitNoNoNoNoYes
Automatic plan invalidationNoNoNoNoYes
Background WriterNoYesYesYesYes
Cross datatype hashing supportNoNoNoNoYes
Distributed checkpointingNoNoNoNoYes
Full Text SearchNoNoNoNoYes
GIN (Generalized Inverted Index) IndexesNoNoNoYesYes
GiST (Generalized Search Tree) IndexesYesYesYesYesYes
Hashing support for NUMERIC NoNoNoNoYes
Heap Only Tuples (HOT)NoNoNoNoYes
In-memory Bitmap IndexesNoNoYesYesYes
Index support for IS NULLNoNoNoNoYes
Indexes on expressionsYesYesYesYesYes
Inlining of SQL-functionsYesYesYesYesYes
Lazy XID allocationNoNoNoNoYes
Multiple temporary tablespacesNoNoNoNoYes
Non-blocking CREATE INDEXNoNoNoYesYes
Outer Join reorderingNoNoNoYesYes
Partial sort capability (top-n sorting)NoNoNoNoYes
SELECT ... FOR UPDATE/SHARE NOWAITNoNoYesYesYes
Shared row level lockingNoNoYesYesYes
Synchronized sequential scanningNoNoNoNoYes
Table partitioningNoNoYesYesYes
TablespacesNoYesYesYesYes
Security 7.48.08.18.28.3
GSSAPI supportNoNoNoNoYes
Native LDAP authenticationNoNoNoYesYes
Per user/database connection limitsNoNoYesYesYes
ROLESNoNoYesYesYes
Security Service Provider Interface (SSPI)NoNoNoNoYes
Network 7.48.08.18.28.3
Full SSL supportYesYesYesYesYes
IPv6 SupportYesYesYesYesYes
V2 client protocolYesYesYesYesYes
V3 client protocolYesYesYesYesYes
Internationalisation 7.48.08.18.28.3
EUC_JIS_2004/ SHIFT_JIS_2004 supportNoNoNoNoYes
Multibyte encoding support, incl. UTF8YesYesYesYesYes
Multiple language supportYesYesYesYesYes
UTF8 support on WindowsNoNoYesYesYes
Platforms 7.48.08.18.28.3
Microsoft Visual C++ SupportNoNoNoNoYes
Native Windows PortNoYesYesYesYes
Datatypes 7.48.08.18.28.3
Array supportYesYesYesYesYes
Arrays of compound typesNoNoNoNoYes
ENUM data typeNoNoNoNoYes
GUID/UUID data typeNoNoNoNoYes
NULLs in ArrayNoNoNoYesYes
Type modifier supportNoNoNoNoYes
XML data typeNoNoNoNoYes
Functions and triggers 7.48.08.18.28.3
ALTER TABLE / ENABLE REPLICA TRIGGER/RULENoNoNoNoYes
ALTER TABLE ENABLE/DISABLE TRIGGERNoNoYesYesYes
Per-function GUC settingsNoNoNoNoYes
Statement level triggersYesYesYesYesYes
Procedural Languages 7.48.08.18.28.3
CONTINUE statement for pl/pgsqlNoNoYesYesYes
EXCEPTION support in pl/pgsqlNoYesYesYesYes
IN/OUT/INOUT parameters for pl/pgsql and pl/SQLNoNoYesYesYes
Named parametersNoYesYesYesYes
Non-superuser language creationNoNoNoNoYes
Number of function arguments increased to 100NoNoYesYesYes
Polymorphic functionsYesYesYesYesYes
Qualified function parameters NoNoNoNoYes
RETURN QUERY in pl/pgsqlNoNoNoNoYes
ROWS and COST specification for functionsNoNoNoNoYes
SQLERRM/SQLSTATE for pl/pgsqlNoNoYesYesYes
Scrollable and updatable cursor support for pl/pgsqlNoNoNoNoYes
Validator function for pl/perlNoNoYesYesYes
contrib modules 7.48.08.18.28.3
contrib/adminpackNoNoNoYesYes
contrib/btree_gistNoYesYesYesYes
contrib/dblinkYesYesYesYesYes
contrib/dbsizeYesYesObsoleteObsoleteObsolete
contrib/fuzzystrmatchYesYesYesYesYes
contrib/hstoreNoNoNoYesYes
contrib/intarrayYesYesYesYesYes
contrib/isn (ISBN)NoNoNoYesYes
contrib/ltreeYesYesYesYesYes
contrib/pageinspectNoNoNoNoYes
contrib/pg_autovacuumYesYesObsoleteObsoleteObsolete
contrib/pg_buffercacheNoNoYesYesYes
contrib/pg_freespacemapNoNoNoYesYes
contrib/pg_standbyNoNoNoNoYes
contrib/pg_trgmNoYesYesYesYes
contrib/pgbenchYesYesYesYesYes
contrib/pgstattupleYesYesYesYesYes
contrib/segYesYesYesYesYes
contrib/sslinfoNoNoNoYesYes
contrib/tablefuncYesYesYesYesYes
contrib/tsearch2YesYesYesYesObsolete
contrib/tsearch2 UTF8 supportNoNoNoYesObsolete
contrib/tsearch2 compat wrapperNoNoNoNoYes
contrib/userlocksYesYesYesObsoleteObsolete
contrib/uuid-osspNoNoNoNoYes
contrib/xml2NoYesYesYesYes

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 – 2008 PostgreSQL Global Development Group