本文详细介绍了PostgreSQL12beta2版本的数据库系统信息，包括编译环境和位数，同时展示了系统内部多个核心表的OID、名称、文件节点及文件路径，涉及pg_class、pg_attribute、pg_proc等关键系统表。
postgres=# select version();
version
------------------------------------------------------------------------------------------------------------
PostgreSQL 12beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
(1 row)
postgres=# select oid,relname,pg_relation_filenode(oid),pg_relation_filepath(oid) from pg_class where relfilenode=0 order by 1;
oid | relname | pg_relation_filenode | pg_relation_filepath
-------+-----------------------------------------+----------------------+----------------------
1136 | pg_pltemplate | 1136 | global/1136
1137 | pg_pltemplate_name_index | 1137 | global/1137
1213 | pg_tablespace | 1213 | global/1213
1214 | pg_shdepend | 1214 | global/1214
1232 | pg_shdepend_depender_index | 1232 | global/1232
1233 | pg_shdepend_reference_index | 1233 | global/1233
1247 | pg_type | 1247 | base/13591/1247
1249 | pg_attribute | 1249 | base/13591/1249
1255 | pg_proc | 1255 | base/13591/1255
1259 | pg_class | 1259 | base/13591/1259
1260 | pg_authid | 1260 | global/1260
1261 | pg_auth_members | 1261 | global/1261
1262 | pg_database | 1262 | global/1262
2396 | pg_shdescription | 2396 | global/2396
2397 | pg_shdescription_o_c_index | 2397 | global/2397
2658 | pg_attribute_relid_attnam_index | 2658 | base/13591/2658
2659 | pg_attribute_relid_attnum_index | 2659 | base/13591/2659
2662 | pg_class_oid_index | 2662 | base/13591/2662
2663 | pg_class_relname_nsp_index | 2663 | base/13591/2663
2671 | pg_database_datname_index | 2671 | global/2671
2672 | pg_database_oid_index | 2672 | global/2672
2676 | pg_authid_rolname_index | 2676 | global/2676
2677 | pg_authid_oid_index | 2677 | global/2677
2690 | pg_proc_oid_index | 2690 | base/13591/2690
2691 | pg_proc_proname_args_nsp_index | 2691 | base/13591/2691
2694 | pg_auth_members_role_member_index | 2694 | global/2694
2695 | pg_auth_members_member_role_index | 2695 | global/2695
2697 | pg_tablespace_oid_index | 2697 | global/2697
2698 | pg_tablespace_spcname_index | 2698 | global/2698
2703 | pg_type_oid_index | 2703 | base/13591/2703
2704 | pg_type_typname_nsp_index | 2704 | base/13591/2704
2836 | pg_toast_1255 | 2836 | base/13591/2836
2837 | pg_toast_1255_index | 2837 | base/13591/2837
2846 | pg_toast_2396 | 2846 | global/2846
2847 | pg_toast_2396_index | 2847 | global/2847
2964 | pg_db_role_setting | 2964 | global/2964
2965 | pg_db_role_setting_databaseid_rol_index | 2965 | global/2965
2966 | pg_toast_2964 | 2966 | global/2966
2967 | pg_toast_2964_index | 2967 | global/2967
3455 | pg_class_tblspc_relfilenode_index | 3455 | base/13591/3455
3592 | pg_shseclabel | 3592 | global/3592
3593 | pg_shseclabel_object_index | 3593 | global/3593
4060 | pg_toast_3592 | 4060 | global/4060
4061 | pg_toast_3592_index | 4061 | global/4061
4171 | pg_toast_1247 | 4171 | base/13591/4171
4172 | pg_toast_1247_index | 4172 | base/13591/4172
4175 | pg_toast_1260 | 4175 | global/4175
4176 | pg_toast_1260_index | 4176 | global/4176
4177 | pg_toast_1262 | 4177 | global/4177
4178 | pg_toast_1262_index | 4178 | global/4178
4179 | pg_toast_1136 | 4179 | global/4179
4180 | pg_toast_1136_index | 4180 | global/4180
4181 | pg_toast_6000 | 4181 | global/4181
4182 | pg_toast_6000_index | 4182 | global/4182
4183 | pg_toast_6100 | 4183 | global/4183
4184 | pg_toast_6100_index | 4184 | global/4184
4185 | pg_toast_1213 | 4185 | global/4185
4186 | pg_toast_1213_index | 4186 | global/4186
6000 | pg_replication_origin | 6000 | global/6000
6001 | pg_replication_origin_roiident_index | 6001 | global/6001
6002 | pg_replication_origin_roname_index | 6002 | global/6002
6100 | pg_subscription | 6100 | global/6100
6114 | pg_subscription_oid_index | 6114 | global/6114
6115 | pg_subscription_subname_index | 6115 | global/6115
12089 | pg_roles | |
12093 | pg_shadow | |
12097 | pg_group | |
12100 | pg_user | |
12103 | pg_policies | |
12107 | pg_rules | |
12111 | pg_views | |
12115 | pg_tables | |
12119 | pg_matviews | |
12123 | pg_indexes | |
12127 | pg_sequences | |
12131 | pg_stats | |
12135 | pg_stats_ext | |
12139 | pg_publication_tables | |
12143 | pg_locks | |
12146 | pg_cursors | |
12149 | pg_available_extensions | |
12152 | pg_available_extension_versions | |
12155 | pg_prepared_xacts | |
12159 | pg_prepared_statements | |
12162 | pg_seclabels | |
12166 | pg_settings | |
12171 | pg_file_settings | |
12174 | pg_hba_file_rules | |
12177 | pg_timezone_abbrevs | |
12180 | pg_timezone_names | |
12183 | pg_config | |
12186 | pg_stat_all_tables | |
12190 | pg_stat_xact_all_tables | |
12194 | pg_stat_sys_tables | |
12198 | pg_stat_xact_sys_tables | |
12201 | pg_stat_user_tables | |
12205 | pg_stat_xact_user_tables | |
12208 | pg_statio_all_tables | |
12212 | pg_statio_sys_tables | |
12215 | pg_statio_user_tables | |
12218 | pg_stat_all_indexes | |
12222 | pg_stat_sys_indexes | |
12225 | pg_stat_user_indexes | |
12228 | pg_statio_all_indexes | |
12232 | pg_statio_sys_indexes | |
12235 | pg_statio_user_indexes | |
12238 | pg_statio_all_sequences | |
12242 | pg_statio_sys_sequences | |
12245 | pg_statio_user_sequences | |
12248 | pg_stat_activity | |
12252 | pg_stat_replication | |
12256 | pg_stat_wal_receiver | |
12259 | pg_stat_subscription | |
12262 | pg_stat_ssl | |
12265 | pg_stat_gssapi | |
12268 | pg_replication_slots | |
12272 | pg_stat_database | |
12276 | pg_stat_database_conflicts | |
12279 | pg_stat_user_functions | |
12283 | pg_stat_xact_user_functions | |
12287 | pg_stat_archiver | |
12290 | pg_stat_bgwriter | |
12293 | pg_stat_progress_vacuum | |
12297 | pg_stat_progress_cluster | |
12301 | pg_stat_progress_create_index | |
12305 | pg_user_mappings | |
12309 | pg_replication_origin_status | |
13311 | information_schema_catalog_name | |
13319 | applicable_roles | |
13323 | administrable_role_authorizations | |
13326 | attributes | |
13330 | character_sets | |
13334 | check_constraint_routine_usage | |
13338 | check_constraints | |
13342 | collations | |
13346 | collation_character_set_applicability | |
13350 | column_column_usage | |
13354 | column_domain_usage | |
13358 | column_privileges | |
13362 | column_udt_usage | |
13366 | columns | |
13370 | constraint_column_usage | |
13374 | constraint_table_usage | |
13378 | domain_constraints | |
13382 | domain_udt_usage | |
13386 | domains | |
13390 | enabled_roles | |
13393 | key_column_usage | |
13397 | parameters | |
13401 | referential_constraints | |
13405 | role_column_grants | |
13408 | routine_privileges | |
13412 | role_routine_grants | |
13415 | routines | |
13419 | schemata | |
13422 | sequences | |
13461 | table_constraints | |
13465 | table_privileges | |
13469 | role_table_grants | |
13472 | tables | |
13476 | transforms | |
13480 | triggered_update_columns | |
13484 | triggers | |
13488 | udt_privileges | |
13492 | role_udt_grants | |
13495 | usage_privileges | |
13499 | role_usage_grants | |
13502 | user_defined_types | |
13506 | view_column_usage | |
13510 | view_routine_usage | |
13514 | view_table_usage | |
13518 | views | |
13522 | data_type_privileges | |
13526 | element_types | |
13530 | _pg_foreign_table_columns | |
13534 | column_options | |
13537 | _pg_foreign_data_wrappers | |
13540 | foreign_data_wrapper_options | |
13543 | foreign_data_wrappers | |
13546 | _pg_foreign_servers | |
13550 | foreign_server_options | |
13553 | foreign_servers | |
13556 | _pg_foreign_tables | |
13560 | foreign_table_options | |
13563 | foreign_tables | |
13566 | _pg_user_mappings | |
13570 | user_mapping_options | |
13574 | user_mappings | |
(188 rows)
postgres=#
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
