Feature Matrix

This indicates the Postgres data definition language features supported by each Pyrseas release. Pyrseas supports Postgres versions 9.4, 9.5, 9.6, 10 and 11. Some of the DDL features are only available in later Postgres versions. Pyrseas can be used with Python 2.7 and starting in version 0.5 with Python 3.2 thorough 3.7.

DDL Feature	0.7	0.6	0.5	0.4	0.3	0.2	0.1
AGGREGATE	X	X	X	X	X
CAST	X	X	X	X
CLUSTER	X
COLLATION	X	X
CONSTRAINT TRIGGER	X	X	X	X
CONVERSION	X	X	X	X
DOMAIN	X	X	X	X	X
EVENT TRIGGER	X
EXTENSION	X	X
FOREIGN DATA WRAPPER	X	X	X
FOREIGN TABLE	X	X	X
FUNCTION	X	X	X	X	X	X
INDEX	X	X	X	X	X	X	X
LANGUAGE	X	X	X	X	X	X
MATERIALIZED VIEWS	X
OPERATOR	X	X	X	X
OPERATOR CLASS	X	X	X	X
OPERATOR FAMILY	X	X	X	X
RULE	X	X	X	X	X
SCHEMA	X	X	X	X	X	X	X
SEQUENCE	X	X	X	X	X	X	X
SERVER	X	X	X
TABLE	X	X	X	X	X	X	X
– CHECK CONSTRAINT	X	X	X	X	X	X	X
– PRIMARY KEY	X	X	X	X	X	X	X
– FOREIGN KEY	X	X	X	X	X	X	X
– UNIQUE CONSTRAINT	X	X	X	X	X	X	X
– INHERIT	X	X	X	X	X	X
– UNLOGGED	X	X
TABLESPACE	X	X
TEXT SEARCH CONFIGURATION	X	X	X
TEXT SEARCH DICTIONARY	X	X	X
TEXT SEARCH PARSER	X	X	X
TEXT SEARCH TEMPLATE	X	X	X
TRIGGER	X	X	X	X	X
TYPE	X	X	X	X	X
– ENUM	X	X	X	X	X
– composite	X	X	X	X
– base type	X	X	X	X
USER MAPPING	X	X	X
VIEW	X	X	X	X	X	X
COMMENT	X	X	X	X	X	X
Object OWNER	X	X
Access privileges	X	X