PostgreSQL feature capabilities

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

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

Groups

Backend
Data Types, Functions, & Operators
Indexing & Constraints
SQL
Data Definition Language (DDL)
Performance
JSON
Partitioning & Inheritance
Views & Materialized Views
Replication
Backup, Restore, & Data Integrity
Upgrade
Data Import & Export
Configuration Management
Security
Transactions and Visibility
VACUUM and Maintenance
Foreign Data Wrappers
Custom Functions, Stored Procedures, & Triggers
Procedural Languages
Extensions
Internationalisation
Client Applications
Additional Modules (contrib)
Network
Platforms
后端
数据类型、函数和运算符
索引和约束
SQL
数据定义语言 (DDL)
性能
分区和继承
视图和物化视图
备份、恢复、数据完整性和复制
数据导入和导出
配置管理
安全
外部数据包装器
自定义函数、存储过程和触发器
过程语言
扩展
国际化
附加模块 (contrib)
网络
平台

742 source capabilities

Backend

Capability	20	19	18	17	16	15	14	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	7.4
64-bit large objects	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Advisory locks	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Custom background workers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Disk based FSM	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Dynamic Background Workers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
EXPLAIN (BUFFERS) support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
EXPLAIN (MEMORY)	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
EXPLAIN (SERIALIZE) support	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
EXPLAIN (WAL) support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
"jsonlog" logging format	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Loadable plugin infrastructure for monitoring the planner	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Payload support for LISTEN/NOTIFY	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
pg_stat_checkpointer system view	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_stat_io - I/O metrics view	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_wait_events system view	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Server statistics in shared memory	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL-standard information schema	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Support for anonymous shared memory	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
XML, JSON and YAML output for EXPLAIN	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown

Data Types, Functions, & Operators

Capability	20	19	18	17	16	15	14	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	7.4
Arrays of compound types	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Array support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
ENUM data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
GUID/UUID data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
macaddr8 data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multiranges	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
NULLs in Array	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Phrase search	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Range types	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
smallserial type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Type modifier support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
UUIDv7	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
XML data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown

Indexing & Constraints

Capability	20	19	18	17	16	15	14	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	7.4
Block-range (BRIN) indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
B-tree bottom-up index deletion	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
B-tree deduplication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Concurrent GiST indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Covering Indexes for B-trees (INCLUDE)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Covering indexes for GiST (INCLUDE)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Deferrable unique constraints	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Exclusion constraints	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
GIN (Generalized Inverted Index) Indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
GIN indexes partial match	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
GIN Index performance and size improvements	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
GiST (Generalized Search Tree) Indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Indexes on expressions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Index-only scans	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Index-only scans on GiST	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Index support for IS NULL	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
In-memory Bitmap Indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
K-nearest neighbor GiST support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
K-nearest neighbor SP-GiST Support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Non-blocking CREATE INDEX	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Parallel B-tree index scans	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallelized CREATE INDEX for BRIN indexes	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallelized CREATE INDEX for B-tree indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallelized CREATE INDEX for GIN indexes	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Skip scan on multicolumn B-tree indexes	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Space-Partitioned GiST (SP-GiST) Indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
SP-GiST indexes for range types	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
UNIQUE NULLS NOT DISTINCT	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
WAL support for hash indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

SQL

Capability	20	19	18	17	16	15	14	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	7.4
ANY_VALUE aggregate	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
FETCH FIRST .. WITH TIES	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
GROUPING SETS, CUBE and ROLLUP support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
INSERT/UPDATE/DELETE RETURNING	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
LATERAL clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
MERGE	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
MERGE ... RETURNING	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multirow VALUES	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Non-decimal integer literals	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
ORDER BY NULLS FIRST/LAST	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
range_agg range type aggregation function	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Recursive Queries	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
regexp_count, regexp_instr, regexp_like	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Return OLD and NEW values from modified rows	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Row-wise comparison	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
SQL standard interval handling	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
SYSTEM_USER	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
TABLE statement	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Underscores (_) for thousands separators	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
unnest/array_agg	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Upsert (INSERT ... ON CONFLICT DO ...)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Window functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
WITHIN GROUP clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
WITH ORDINALITY clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
WITH Queries (Common Table Expressions)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Writable WITH Queries (Common Table Expressions)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown

Data Definition Language (DDL)

Capability	20	19	18	17	16	15	14	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	7.4
ALTER object IF EXISTS	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
ALTER TABLE ... SET ACCESS METHOD	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
ALTER TABLE ... SET LOGGED / UNLOGGED	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
CREATE ACCESS METHOD	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
CREATE TABLE ... (LIKE) with foreign tables, views and composite types	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
DROP object IF EXISTS	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
ON COMMIT clause for CREATE TEMPORARY TABLE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
REINDEX CONCURRENTLY	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Stored Generated Columns	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Temporal constraints	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Typed tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Virtual Generated Columns	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Performance

Capability	20	19	18	17	16	15	14	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	7.4
Abbreviated Keys	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Asynchronous Commit	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Asynchronous I/O (AIO)	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Automatic plan invalidation	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Background Checkpointer	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Background Writer	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Base backup throttling	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
CREATE STATISTICS - most-common values (MCV) statistics	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
CREATE STATISTICS - multicolumn	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
CREATE STATISTICS - "OR" and "IN/ANY" statistics	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Cross datatype hashing support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Distributed checkpointing	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Foreign keys marked as NOT VALID	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Frozen page map	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Full Text Search	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Hash aggregation can use disk	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Hashing support for FULL OUTER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Heap Only Tuples (HOT)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Improved performance for sorts exceeding working memory	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Improved window function performance	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Incremental sort	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Incremental sort for SELECT DISTINCT	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Incremental sort for window functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Inlined WITH Queries (Common Table Expressions)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Inlining of SQL-functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Just-in-Time (JIT) compilation for expression evaluation and tuple deforming	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Load balancing for libpq / psql	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
LZ4 compression for TOAST tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multi-core scalability for read-only workloads	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Multiple temporary tablespaces	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Outer Join reordering	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Parallel bitmap heap scans	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel FULL and RIGHT joins	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel full table scans (sequential scans)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel hash joins	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel JOIN, aggregate	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel merge joins	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel query	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel "SELECT DISTINCT"	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Partial sort capability (top-n sorting)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Query pipelining	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Reduced lock levels for ALTER TABLE commands	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
SELECT ... FOR UPDATE/SHARE NOWAIT	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Set costs specific to TABLESPACEs	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Shared row level locking	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
SIMD support for ARM	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SIMD support for x86	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SKIP LOCKED clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Synchronized sequential scanning	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
TABLESAMPLE clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Tablespaces	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Unlogged tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
WAL Buffer auto-tuning	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown

JSON

Capability	20	19	18	17	16	15	14	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	7.4
Improved set of JSON functions and operators	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
JSONB data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
JSONB-modifying operators and functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
JSONB Subscripting	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
JSON data type	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON constructors	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON: datetime()	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON IS JSON	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON JSON_TABLE	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON path expressions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SQL/JSON query functions	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Partitioning & Inheritance

Capability	20	19	18	17	16	15	14	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	7.4
Accelerated partition pruning	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Declarative table partitioning	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Default Partition	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Foreign Key references for partitioned tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Foreign table inheritance	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Partitioning by a hash key	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Partition pruning during query execution	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Support for PRIMARY KEY, FOREIGN KEY, indexes, and triggers on partitioned tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Table Partitioning	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
UPDATE on a partition key	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Views & Materialized Views

Capability	20	19	18	17	16	15	14	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	7.4
Materialized Views	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Materialized views with concurrent refresh	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
SECURITY INVOKER views	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Temporary VIEWs	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Updatable views	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
WITH CHECK clause	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown

Replication

Capability	20	19	18	17	16	15	14	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	7.4
ALTER SUBSCRIPTION ... SKIP	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Cascading streaming replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Configure max WAL retention for replication slots	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Failover support for logical replication slots	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication avoids replication loops	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication column lists	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication for partitioned tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication from standbys	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication of stored generated columns	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication initial sync using binary protocol	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication lookups with additional indexes	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication parallel apply of transactions	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication publish all tables in schema	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication row filtering	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication slots migrate through pg_upgrade migrate	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication stream in-progress transactions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication subscriber can disable on error	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Logical replication write conflict logging	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Quorum commit for synchronous replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Replication Slots	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
Streaming-only cascading replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Streaming Replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Synchronous replication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown

Backup, Restore, & Data Integrity

Capability	20	19	18	17	16	15	14	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	7.4
Archive modules	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Checksum on data pages	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Enable/Disable page checksums in an offline cluster	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Generic WAL facility	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Hot Standby	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
lz4 and Zstandard (zstd) compression for WAL full page writes	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
min_wal_size / max_wal_size	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multiple synchronous standbys	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Named restore points	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Parallel pg_dump	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Parallel restore	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
pg_basebackup client decompression	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_basebackup incremental backup	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_basebackup server-side compression	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_basebackup tool	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
pg_dump, pg_dumpall, pg_restore --filter	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_receivewal (formerly pg_receivexlog)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Point-in-Time Recovery	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Pre-fetch WAL during recovery	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
remote_apply mode	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Time-delayed Standbys	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
Verify backup integrity (pg_verifybackup)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Warm Standby	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown

Upgrade

Capability	20	19	18	17	16	15	14	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	7.4
pg_upgrade --swap	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Planner statistics preserved on major version upgrade	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Data Import & Export

Capability	20	19	18	17	16	15	14	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	7.4
COPY from/to STDIN/STDOUT	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
COPY FROM ... WHERE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
COPY ... ON_ERROR	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
COPY with arbitrary SELECT	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
CSV support for COPY	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown

Configuration Management

Capability	20	19	18	17	16	15	14	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	7.4
ALTER SYSTEM	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
Fractional input for "integer" values	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Include directives for pg_hba.conf and pg_ident.conf	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Per user/database server configuration settings	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
pg_config system view	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Regular expression matching in pg_hba.conf and pg_ident.conf	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Security

Capability	20	19	18	17	16	15	14	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	7.4
Channel binding for SCRAM authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Client can require SCRAM channel binding	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Client-specified requirements for authentication	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Column level permissions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Default permissions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Direct TLS negotiation ("sslnegotiation")	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
FIPS mode validation	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
GSSAPI client and server-side encryption	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
GSSAPI support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Kerberos credential delegation	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
krb5 authentication (without gssapi)	Unknown	Unknown	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Large object access controls	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
LDAP server discovery	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multifactor authentication via valid client SSL/TLS certificate	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Native LDAP authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
Native RADIUS authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
OAuth Authentication / Authorization	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Per user/database connection limits	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Predefined roles	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Privileges for setting configuration parameters	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
ROLES	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Row-Level Security	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SCRAM-SHA-256 Authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Search+bind mode operation for LDAP authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
security_barrier option on views	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
Security Service Provider Interface (SSPI)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
SHA-2 encryption for password hashing	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
SSL certificate validation in libpq	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
SSL client certificate authentication	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
SSPI authentication via GSSAPI	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Support using the client's OS trusted CA.	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
TLS v1.3 cipher suite allowlisting	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Transactions and Visibility

Capability	20	19	18	17	16	15	14	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	7.4
Cursors	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Savepoints	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Serializable Snapshot Isolation	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Two Phase commit	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Updatable cursors	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown

VACUUM and Maintenance

Capability	20	19	18	17	16	15	14	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	7.4
Inserted data can trigger autovacuum	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Integrated autovacuum daemon	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Page freezing optimizations	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallelized VACUUM for Indexes	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel vacuumdb jobs	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Radix tree memory structure for vacuum	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Vacuum "emergency mode"	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Visibility Map for Vacuuming	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown

Foreign Data Wrappers

Capability	20	19	18	17	16	15	14	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	7.4
Certificate authentication with postgres_fdw	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
CREATE FOREIGN TABLE ... LIKE	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Foreign data wrapper query parallelism	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Foreign data wrappers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Foreign Tables	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
IMPORT FOREIGN SCHEMA	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Import foreign table partitions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Parallel query execution on remote databases	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
postgres_fdw parallel commit	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
postgres_fdw pushdown	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
postgres_fdw SCRAM authentication passthrough	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
PostgreSQL Foreign Data Wrapper	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
Writable Foreign Data Wrappers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown

Custom Functions, Stored Procedures, & Triggers

Capability	20	19	18	17	16	15	14	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	7.4
ALTER TABLE ENABLE/DISABLE TRIGGER	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
ALTER TABLE / ENABLE REPLICA TRIGGER/RULE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
BEGIN ATOMIC function bodies	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
CALL syntax for executing procedures	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Column level triggers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
CREATE PROCEDURE syntax for SQL stored procedures	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Event triggers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
FILTER clause for aggregate functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
ORDER BY support within aggregates	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Per function GUC settings	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Per function statistics	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
RETURN QUERY EXECUTE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
RETURNS TABLE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Statement level triggers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Statement level TRUNCATE triggers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Triggers on views	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Variadic functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
WHEN clause for CREATE TRIGGER	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown

Procedural Languages

Capability	20	19	18	17	16	15	14	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	7.4
CASE in pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
CONTINUE statement for PL/pgSQL	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
CREATE TRANSFORM	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
DO statement for pl/perl	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
DO statement for pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
EXCEPTION support in PL/pgSQL	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
EXECUTE USING in PL/pgSQL	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
FOREACH IN ARRAY in pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
IN/OUT/INOUT parameters for pl/pgsql and PL/SQL	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Named parameters	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Non-superuser language creation	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
pl/pgsql installed by default	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Polymorphic functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Python 3 support for pl/python	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Qualified function parameters	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Query parallelism for RETURN QUERY	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
RETURN QUERY in pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
ROWS and COST specification for functions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Scrollable and updatable cursor support for pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
SQLERRM/SQLSTATE for pl/pgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Unicode object support in PL/python	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
User defined exceptions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Validator function for pl/perl	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown

Extensions

Capability	20	19	18	17	16	15	14	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	7.4
CREATE EXTENSION .. CASCADE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Extension Installation	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Trusted Extensions	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown

Internationalisation

Capability	20	19	18	17	16	15	14	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	7.4
Built-in, platform independent immutable collation	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
casefold	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Column-level collation support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
Database level Collation	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Default ICU collations for clusters/databases	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
EUC_JIS_2004/ SHIFT_JIS_2004 support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
ICU collations	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
LIKE comparisons for nondeterministic collations	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Multibyte encoding support, incl. UTF8	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Multiple language support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Nondeterministic collations	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_unicode_fast collation	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Unicode string literals and identifiers	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
UTF8 support on Windows	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown

Client Applications

Capability	20	19	18	17	16	15	14	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	7.4
pgbench	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
pg_combinebackup	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_createsubscriber	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_prewarm	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_rewind	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_standby	Unknown	Unknown	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
pg_upgrade	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
pg_waldump	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_walsummary	Unknown	Unknown	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_xlogdump	Unknown	Unknown	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
psql \bind	Unknown	Unknown	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
psql \dconfig	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
psql pipeline queries	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
psql named prepared statements	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
Version aware psql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown

Additional Modules (contrib)

Capability	20	19	18	17	16	15	14	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	7.4
adminpack	Unknown	Unknown	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
auth_delay	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
auto_explain	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
btree_gin	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
btree_gist	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
citext	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
dblink	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
dblink asyncronous notification support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
file_fdw	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
fuzzystrmatch	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
hstore	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
intarray	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
isn (ISBN)	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
KNN support for CUBE	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
ltree	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
pageinspect	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
passwordcheck	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
pg_buffercache	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
pg_freespacemap	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
pg_logicalinspect	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_overexplain	Unknown	Unknown	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
pg_stat_statements	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
pg_stat_statements improvements	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
pgstattuple	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
pg_trgm	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
pg_trgm regular expressions indexing	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	Unknown	Unknown
pg_walinspect	Unknown	Unknown	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	Unknown	Unknown
seg	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
sepgsql	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	Unknown	Unknown
sslinfo	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Unknown	Unknown
tablefunc	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
tcn	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	Unknown	Unknown
tsearch2 compatibility wrapper	Unknown	Unknown	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
unaccent	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
uuid-ossp	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
xml2	Unknown	Unknown	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Unknown	Unknown

Network

Capability	20	19	18	17	16	15	14	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	7.4
Full SSL support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
IPv6 Support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
V2 client protocol	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Unknown	Unknown
V3 client protocol	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown

Platforms

Capability	20	19	18	17	16	15	14	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	7.4
Microsoft Visual C++ Support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Unknown	Unknown
Native Windows Port	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Unknown	Unknown
Spinlock support for the SuperH hardware platform	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown
Sun Studio compiler on Linux	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Unknown	Unknown
Windows x64 support	Unknown	Unknown	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	Unknown	Unknown

后端

Capability	20	19	18	17	16	15	14	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	7.4
默认启用 autovacuum	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
多 autovacuum 工作进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
美元引用	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
unnest/array_agg	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
基于磁盘的 FSM	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
版本感知的 psql	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
用于 Vacuuming 的可见性图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
EXPLAIN 的 XML、JSON 和 YAML 输出	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
文本搜索同义词字典的前缀支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
EXPLAIN (BUFFERS) 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
LISTEN/NOTIFY 的有效载荷支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
ECPG 的 SQLDA 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
命名恢复点	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
可串行快照隔离	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
可更新游标	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
64位大对象	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
匿名共享内存支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
自定义后台工作进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
动态后台工作进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
用于监控规划器的可加载插件基础设施	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
并行 vacuumdb 作业	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
索引的并行 VACUUM	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
插入的数据可触发自动 vacuum	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
EXPLAIN (WAL) 支持	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
咨询锁	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
两阶段提交	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
集成自动 vacuum 守护进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
保存点	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
SQL 标准信息模式	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
可持有游标	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

数据类型、函数和运算符

Capability	20	19	18	17	16	15	14	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	7.4
类型修饰符支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
JSON 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
范围类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
smallserial 类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
改进的 JSON 函数和运算符集	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
JSONB 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
JSONB 修改运算符和函数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
短语搜索	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
复合类型的数组	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
macaddr8 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
GUID/UUID 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
ENUM 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
XML 数据类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
SQL/JSON: datetime()	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
数组中的 NULL	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
数组支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

索引和约束

Capability	20	19	18	17	16	15	14	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	7.4
IS NULL 的索引支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
并发 GiST 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
GIN 索引部分匹配	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
可延迟唯一约束	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
排除约束	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
仅索引扫描	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
空间分区 GiST (SP-GiST) 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
范围类型的 SP-GiST 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
GIN 索引性能和大小改进	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
块范围 (BRIN) 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
GiST 上的仅索引扫描	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
并行 B-tree 索引扫描	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
哈希索引的 WAL 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
B-tree 索引的并行 CREATE INDEX	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
B-tree 的覆盖索引 (INCLUDE)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
GiST 的覆盖索引 (INCLUDE)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
K-最近邻 SP-GiST 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
B-tree 去重	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
非阻塞 CREATE INDEX	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
GIN (广义反向索引) 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
内存位图索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
GiST (广义搜索树) 索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
表达式索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

SQL

Capability	20	19	18	17	16	15	14	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	7.4
WITH 查询 (公用表表达式)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
SQL 标准间隔处理	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
TABLE 语句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
窗口函数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
可写 WITH 查询 (公用表表达式)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
LATERAL 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE 锁定模式	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
ORDER BY NULLS FIRST/LAST	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
WITHIN GROUP 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
WITH ORDINALITY 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
Upsert (INSERT ... ON CONFLICT DO ...)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
GROUPING SETS, CUBE 和 ROLLUP 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
SQL/JSON 路径表达式	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
递归查询	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
FETCH FIRST .. WITH TIES	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
INSERT/UPDATE/DELETE RETURNING	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
多行 VALUES	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
行式比较	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No

数据定义语言 (DDL)

Capability	20	19	18	17	16	15	14	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	7.4
类型化表	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
ALTER object IF EXISTS	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
CREATE TABLE ... (LIKE) 包含外部表、视图和复合类型	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
ALTER TABLE ... SET LOGGED / UNLOGGED	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
存储生成的列	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
REINDEX CONCURRENTLY	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
CREATE ACCESS METHOD	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
DROP object IF EXISTS	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
更改列类型 (ALTER TABLE .. ALTER COLUMN TYPE)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
CREATE TEMPORARY TABLE 的 ON COMMIT 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

性能

Capability	20	19	18	17	16	15	14	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	7.4
分布式检查点	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
跨数据类型哈希支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
DISTINCT/UNION/INTERSECT/EXCEPT 的哈希支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
并行恢复	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
为 TABLESPACE 设置特定成本	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
K-最近邻 GiST 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
未记录表	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
FULL OUTER JOIN、LEFT OUTER JOIN 和 RIGHT OUTER JOIN 的哈希支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
WAL 缓冲区自动调优	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
全文搜索	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
标记为 NOT VALID 的外键	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
只读工作负载的多核可伸缩性	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
后台检查点进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
部分排序能力 (top-n 排序)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
ALTER TABLE 命令的锁定级别降低	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
同步顺序扫描	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
基础备份节流	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
pg_prewarm	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
SKIP LOCKED 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
TABLESAMPLE 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
缩写键	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
多个临时表空间	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
并行查询	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
并行全表扫描 (顺序扫描)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
并行 JOIN、聚合	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
已冻结页面映射	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
并行位图堆扫描	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
并行合并连接	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
并行哈希连接	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
表达式求值和元组解构的即时 (JIT) 编译	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
CREATE STATISTICS - 多列	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
CREATE STATISTICS - 最常用值 (MCV) 统计信息	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
加速分区裁剪	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
内联 WITH 查询 (公用表表达式)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
查询执行期间的分区裁剪	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
增量排序	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
CREATE STATISTICS - "OR" 和 "IN/ANY" 统计信息	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
基于磁盘的哈希聚合	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
自动计划无效化	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
仅堆元组 (HOT)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
外连接重排序	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
共享行级锁定	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
SELECT ... FOR UPDATE/SHARE NOWAIT	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
表空间	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
后台写入进程	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
SQL 函数的内联	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
异步提交	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No

分区和继承

Capability	20	19	18	17	16	15	14	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	7.4
外部表继承	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
声明式表分区	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
按哈希键分区	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
分区表的 PRIMARY KEY、FOREIGN KEY、索引和触发器支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
默认分区	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
分区键上的 UPDATE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
分区表的外部键引用	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
分区表的逻辑复制	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
表分区	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No

视图和物化视图

Capability	20	19	18	17	16	15	14	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	7.4
可更新视图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
物化视图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
带并发刷新的物化视图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
WITH CHECK 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
临时视图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No

备份、恢复、数据完整性和复制

Capability	20	19	18	17	16	15	14	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	7.4
温备	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
热备	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
流复制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
同步复制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
pg_basebackup 工具	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
级联流复制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
pg_receivewal (原 pg_receivexlog)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
并行 pg_dump	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
数据页校验和	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
仅流式复制的级联复制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
复制槽	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
延迟备用服务器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
min_wal_size / max_wal_size	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
多个同步备用服务器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
remote_apply 模式	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
通用 WAL 机制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
逻辑复制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
同步复制的仲裁提交	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
在离线集群中启用/禁用页面校验和	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
配置复制槽的最大 WAL 保持时间	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
验证备份完整性 (pg_verifybackup)	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
按时间点恢复	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

数据导入和导出

Capability	20	19	18	17	16	15	14	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	7.4
COPY 到/从 STDIN/STDOUT	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
COPY FROM ... WHERE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
带任意 SELECT 的 COPY	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
COPY 的 CSV 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

配置管理

Capability	20	19	18	17	16	15	14	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	7.4
每个用户/数据库的服务器配置设置	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
ALTER SYSTEM	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
pg_config 系统视图	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
"整数"值的小数输入	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No

安全

Capability	20	19	18	17	16	15	14	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	7.4
安全服务提供商接口 (SSPI)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
libpq 中的 SSL 证书验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
SSL 客户端证书身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
列级别权限	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
默认权限	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
大对象访问控制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
LDAP 身份验证的 Search+bind 模式操作	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
原生 RADIUS 身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
通过 GSSAPI 进行 SSPI 身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
GSSAPI 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
视图上的 security_barrier 选项	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
krb5 身份验证 (无 gssapi)	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
行级安全	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
SCRAM-SHA-256 身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
SCRAM 身份验证的通道绑定	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
GSSAPI 客户端和服务器端加密	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
LDAP 服务器发现	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
通过有效的客户端 SSL/TLS 证书进行多因素身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
客户端可要求 SCRAM 通道绑定	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No
原生 LDAP 身份验证	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
ROLES	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
每个用户/数据库的连接限制	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No

外部数据包装器

Capability	20	19	18	17	16	15	14	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	7.4
外部表	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
可写外部数据包装器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
外部数据包装器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
PostgreSQL 外部数据包装器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
IMPORT FOREIGN SCHEMA	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
postgres_fdw 下推	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
postgres_fdw 的证书身份验证	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No

自定义函数、存储过程和触发器

Capability	20	19	18	17	16	15	14	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	7.4
ALTER TABLE / ENABLE REPLICA TRIGGER/RULE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
语句级 TRUNCATE 触发器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
RETURNS TABLE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
可变参数函数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
每个函数的统计信息	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
RETURN QUERY EXECUTE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
列级别触发器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
CREATE TRIGGER 的 WHEN 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
聚合内的 ORDER BY 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
每个函数的 GUC 设置	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
视图上的触发器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
事件触发器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
聚合函数的 FILTER 子句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No
SQL 存储过程的 CREATE PROCEDURE 语法	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
执行过程的 CALL 语法	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No
ALTER TABLE ENABLE/DISABLE TRIGGER	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
语句级触发器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

过程语言

Capability	20	19	18	17	16	15	14	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	7.4
非超级用户语言创建	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
PL/pgSQL 中的 EXECUTE USING	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
pl/pgsql 的可滚动和可更新游标支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
pl/pgsql 中的 CASE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
用户定义异常	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
函数的 ROWS 和 COST 规范	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
pl/pgsql 的 SQLERRM/SQLSTATE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
pl/pgsql 的 DO 语句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
PL/python 中的 Unicode 对象支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
pl/pgsql 默认安装	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
pl/perl 的 DO 语句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
pl/python 的 Python 3 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
pl/pgsql 中的 FOREACH IN ARRAY	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
CREATE TRANSFORM	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
pl/pgsql 中的 RETURN QUERY	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
限定函数参数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
pl/pgsql 和 PL/SQL 的 IN/OUT/INOUT 参数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
PL/pgSQL 的 CONTINUE 语句	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
pl/perl 的验证器函数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
命名参数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
PL/pgSQL 中的 EXCEPTION 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
多态函数	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

扩展

Capability	20	19	18	17	16	15	14	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	7.4
扩展安装	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
CREATE EXTENSION .. CASCADE	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
受信任的扩展	Unknown	Unknown	No	No	No	No	No	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No

国际化

Capability	20	19	18	17	16	15	14	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	7.4
Windows 上的 UTF8 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
多字节编码支持，包括 UTF8	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
多语言支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
数据库级别排序规则	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Unicode 字符串文字和标识符	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
EUC_JIS_2004/ SHIFT_JIS_2004 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
列级别排序规则支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
ICU 排序规则	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No
非确定性排序规则	Unknown	Unknown	No	No	No	No	No	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No	No	No	No

附加模块 (contrib)

Capability	20	19	18	17	16	15	14	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	7.4
contrib/pgbench	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/seg	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/tablefunc	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/pgstattuple	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/dblink	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/adminpack	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
contrib/fuzzystrmatch	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/pg_buffercache	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
contrib/ltree	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
contrib/intarray	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
tsearch2 兼容性包装器	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
contrib/citext	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
contrib/autoexplain	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
contrib/pg_stat_statements	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
contrib/btree_gin	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
contrib/tsearch2 UTF8 支持	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	No	No	No
contrib/unaccent	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
dblink 异步通知支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
contrib/dbsize	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes
contrib/passwordcheck	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
contrib/pg_upgrade	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
contrib/sepgsql	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
contrib/auth_delay	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
contrib/file_fdw	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No
contrib/tcn	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
pg_stat_statements 改进	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No
contrib/pg_xlogdump	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
pg_trgm 正则表达式索引	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No
contrib/pg_rewind	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No
CUBE 的 KNN 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No	No	No	No	No	No	No
contrib/pageinspect	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
contrib/uuid-ossp	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
contrib/pg_standby	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
contrib/pg_freespacemap	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
contrib/isn (ISBN)	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
contrib/hstore	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
contrib/sslinfo	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No
contrib/xml2	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes	No
contrib/pg_trgm	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
contrib/btree_gist	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
contrib/tsearch2	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes	Yes
contrib/userlocks	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes	Yes
contrib/pg_autovacuum	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Yes	Yes

网络

Capability	20	19	18	17	16	15	14	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	7.4
V2 客户端协议	Unknown	Unknown	No	No	No	No	No	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete	Obsolete
完整的 SSL 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
IPv6 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
V3 客户端协议	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

平台

Capability	20	19	18	17	16	15	14	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	7.4
Linux 上的 Sun Studio 编译器	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
SuperH 硬件平台的自旋锁支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
Windows x64 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
Microsoft Visual C++ 支持	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
原生 Windows 端口	Unknown	Unknown	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Complete source data JSON