THE POSTGRESQL CATALOG ATLAS

读懂 PostgreSQL 的每一次演化。

从 9.0 到今天，沿着系统目录的脉络，
探索数据库内部结构，发现版本之间的变化。

比较版本差异 ↗获取开放数据 ↓

17个大版本

157个系统目录与视图

2010 — 2026跨越十六年的演变

官方文档 · 可复现数据 ↗

EXPLORE THE CATALOG

一张图，看见版本的全貌。

19 beta 3 · 预发布

PostgreSQL 各版本系统目录可用性及相邻版本结构变更
目录名称 157
pg_aggregateCAT
pg_aiosVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_amCAT
pg_amopCAT
pg_amprocCAT
pg_attrdefCAT
pg_attributeCAT
pg_auth_membersCAT
pg_authidCAT
pg_available_extension_versionsVIEW	–
pg_available_extensionsVIEW	–
pg_backend_memory_contextsVIEW	–	–	–	–	–	–	–	–	–	–	–
pg_castCAT
pg_classCAT
pg_collationCAT	–
pg_configVIEW	–	–	–	–	–	–
pg_constraintCAT
pg_conversionCAT
pg_cursorsVIEW
pg_databaseCAT
pg_db_role_settingCAT
pg_default_aclCAT
pg_dependCAT
pg_descriptionCAT
pg_dsm_registry_allocationsVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_enumCAT
pg_event_triggerCAT	–	–	–
pg_extensionCAT	–
pg_file_settingsVIEW	–	–	–	–	–
pg_foreign_data_wrapperCAT
pg_foreign_serverCAT
pg_foreign_tableCAT	–
pg_groupVIEW
pg_hba_file_rulesVIEW	–	–	–	–	–	–	–
pg_ident_file_mappingsVIEW	–	–	–	–	–	–	–	–	–	–	–	–
pg_indexCAT
pg_indexesVIEW
pg_inheritsCAT
pg_init_privsCAT	–	–	–	–	–	–
pg_languageCAT
pg_largeobjectCAT
pg_largeobject_metadataCAT
pg_locksVIEW
pg_matviewsVIEW	–	–	–
pg_namespaceCAT
pg_opclassCAT
pg_operatorCAT
pg_opfamilyCAT
pg_parameter_aclCAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_partitioned_tableCAT	–	–	–	–	–	–	–
pg_pltemplateCAT											–	–	–	–	–	–	–
pg_policiesVIEW	–	–	–	–	–
pg_policyCAT	–	–	–	–	–
pg_prepared_statementsVIEW
pg_prepared_xactsVIEW
pg_procCAT
pg_propgraph_elementCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_element_labelCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_labelCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_label_propertyCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_propertyCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_publicationCAT	–	–	–	–	–	–	–
pg_publication_namespaceCAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_publication_relCAT	–	–	–	–	–	–	–
pg_publication_sequencesVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_publication_tablesVIEW	–	–	–	–	–	–	–
pg_rangeCAT	–	–
pg_replication_originCAT	–	–	–	–	–
pg_replication_origin_statusVIEW	–	–	–	–	–
pg_replication_slotsVIEW	–	–	–	–
pg_rewriteCAT
pg_rolesVIEW
pg_rulesVIEW
pg_seclabelCAT	–
pg_seclabelsVIEW	–
pg_sequenceCAT	–	–	–	–	–	–	–
pg_sequencesVIEW	–	–	–	–	–	–	–
pg_settingsVIEW
pg_shadowVIEW
pg_shdependCAT
pg_shdescriptionCAT
pg_shmem_allocationsVIEW	–	–	–	–	–	–	–	–	–	–
pg_shmem_allocations_numaVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_shseclabelCAT	–	–
pg_stat_activitySTAT
pg_stat_all_indexesSTAT
pg_stat_all_tablesSTAT
pg_stat_archiverSTAT	–	–	–	–
pg_stat_autovacuum_scoresSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_bgwriterSTAT
pg_stat_checkpointerSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_databaseSTAT
pg_stat_database_conflictsSTAT	–
pg_stat_gssapiSTAT	–	–	–	–	–	–	–	–	–
pg_stat_ioSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_lockSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_analyzePROG	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_basebackupPROG	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_clusterPROG	–	–	–	–	–	–	–	–	–
pg_stat_progress_copyPROG	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_create_indexPROG	–	–	–	–	–	–	–	–	–
pg_stat_progress_data_checksumsPROG	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_repackPROG	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_vacuumPROG	–	–	–	–	–	–
pg_stat_recoverySTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_recovery_prefetchSTAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_replicationSTAT	–
pg_stat_replication_slotsSTAT	–	–	–	–	–	–	–	–	–	–	–
pg_stat_slruSTAT	–	–	–	–	–	–	–	–	–	–
pg_stat_sslSTAT	–	–	–	–	–
pg_stat_subscriptionSTAT	–	–	–	–	–	–	–
pg_stat_subscription_statsSTAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_sys_indexesSTAT
pg_stat_sys_tablesSTAT
pg_stat_user_functionsSTAT
pg_stat_user_indexesSTAT
pg_stat_user_tablesSTAT
pg_stat_walSTAT	–	–	–	–	–	–	–	–	–	–	–
pg_stat_wal_receiverSTAT	–	–	–	–	–	–
pg_stat_xact_all_tablesSTAT	–
pg_stat_xact_sys_tablesSTAT	–
pg_stat_xact_user_functionsSTAT	–
pg_stat_xact_user_tablesSTAT	–
pg_statio_all_indexesSTAT
pg_statio_all_sequencesSTAT
pg_statio_all_tablesSTAT
pg_statio_sys_indexesSTAT
pg_statio_sys_sequencesSTAT
pg_statio_sys_tablesSTAT
pg_statio_user_indexesSTAT
pg_statio_user_sequencesSTAT
pg_statio_user_tablesSTAT
pg_statisticCAT
pg_statistic_extCAT	–	–	–	–	–	–	–
pg_statistic_ext_dataCAT	–	–	–	–	–	–	–	–	–
pg_statsVIEW
pg_stats_extVIEW	–	–	–	–	–	–	–	–	–
pg_stats_ext_exprsVIEW	–	–	–	–	–	–	–	–	–	–	–
pg_subscriptionCAT	–	–	–	–	–	–	–
pg_subscription_relCAT	–	–	–	–	–	–	–
pg_tablesVIEW
pg_tablespaceCAT
pg_timezone_abbrevsVIEW
pg_timezone_namesVIEW
pg_transformCAT	–	–	–	–	–
pg_triggerCAT
pg_ts_configCAT
pg_ts_config_mapCAT
pg_ts_dictCAT
pg_ts_parserCAT
pg_ts_templateCAT
pg_typeCAT
pg_userVIEW
pg_user_mappingCAT
pg_user_mappingsVIEW
pg_viewsVIEW
pg_wait_eventsVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–

点击目录查看字段与演化时间线；点击版本格直接进入该版本。结构变更包括新增、移除、字段类型变化，描述文字的变化单独记录。