FOLLOW THE EVOLUTION

PostgreSQL 10 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

FROMTOInclude description updates

PostgreSQL 9.6 → 10

pg_attributeStructural change

+ attidentity

pg_classStructural change

+ relispartition+ relpartbound

pg_collationStructural change

+ collprovider+ collversion

+ line_number+ type+ database+ user_name+ address+ netmask+ auth_method+ options+ error

+ partrelid+ partstrat+ partnatts+ partattrs+ partclass+ partcollation+ partexprs

pg_policiesStructural change

+ permissive

pg_policyStructural change

+ polpermissive

+ oid+ pubname+ pubowner+ puballtables+ pubinsert+ pubupdate+ pubdelete

+ oid+ prpubid+ prrelid

+ pubname+ schemaname+ tablename

+ temporary

pg_sequenceCatalog added

+ seqrelid+ seqtypid+ seqstart+ seqincrement+ seqmax+ seqmin+ seqcache+ seqcycle

pg_sequencesCatalog added

+ schemaname+ sequencename+ sequenceowner+ data_type+ start_value+ min_value+ max_value+ increment_by+ cycle+ cache_size+ last_value

pg_stat_activityStructural change

+ backend_type

+ sent_lsn+ write_lsn+ flush_lsn+ replay_lsn+ write_lag+ flush_lag+ replay_lag− sent_location− write_location− flush_location− replay_location

+ subid+ subname+ pid+ relid+ received_lsn+ last_msg_send_time+ last_msg_receipt_time+ latest_end_lsn+ latest_end_time

+ oid+ stxrelid+ stxname+ stxnamespace+ stxowner+ stxkeys+ stxkind+ stxndistinct+ stxdependencies

+ oid+ subdbid+ subname+ subowner+ subenabled+ subconninfo+ subslotname+ subsynccommit+ subpublications

+ srsubid+ srrelid+ srsubstate+ srsublsn

pg_triggerStructural change

+ tgoldtable+ tgnewtable