第 52 章 系统目录

目录

52.1. 概述

52.2. pg_aggregate

52.3. pg_am

52.4. pg_amop

52.5. pg_amproc

52.6. pg_attrdef

52.7. pg_attribute

52.8. pg_authid

52.9. pg_auth_members

52.10. pg_cast

52.11. pg_class

52.12. pg_collation

52.13. pg_constraint

52.14. pg_conversion

52.15. pg_database

52.16. pg_db_role_setting

52.17. pg_default_acl

52.18. pg_depend

52.19. pg_description

52.20. pg_enum

52.21. pg_event_trigger

52.22. pg_extension

52.23. pg_foreign_data_wrapper

52.24. pg_foreign_server

52.25. pg_foreign_table

52.26. pg_index

52.27. pg_inherits

52.28. pg_init_privs

52.29. pg_language

52.30. pg_largeobject

52.31. pg_largeobject_metadata

52.32. pg_namespace

52.33. pg_opclass

52.34. pg_operator

52.35. pg_opfamily

52.36. pg_partitioned_table

52.37. pg_pltemplate

52.38. pg_policy

52.39. pg_proc

52.40. pg_publication

52.41. pg_publication_rel

52.42. pg_range

52.43. pg_replication_origin

52.44. pg_rewrite

52.45. pg_seclabel

52.46. pg_sequence

52.47. pg_shdepend

52.48. pg_shdescription

52.49. pg_shseclabel

52.50. pg_statistic

52.51. pg_statistic_ext

52.52. pg_subscription

52.53. pg_subscription_rel

52.54. pg_tablespace

52.55. pg_transform

52.56. pg_trigger

52.57. pg_ts_config

52.58. pg_ts_config_map

52.59. pg_ts_dict

52.60. pg_ts_parser

52.61. pg_ts_template

52.62. pg_type

52.63. pg_user_mapping

52.64. 系统视图

52.65. pg_available_extensions

52.66. pg_available_extension_versions

52.67. pg_config

52.68. pg_cursors

52.69. pg_file_settings

52.70. pg_group

52.71. pg_hba_file_rules

52.72. pg_indexes

52.73. pg_locks

52.74. pg_matviews

52.75. pg_policies

52.76. pg_prepared_statements

52.77. pg_prepared_xacts

52.78. pg_publication_tables

52.79. pg_replication_origin_status

52.80. pg_replication_slots

52.81. pg_roles

52.82. pg_rules

52.83. pg_seclabels

52.84. pg_sequences

52.85. pg_settings

52.86. pg_shadow

52.87. pg_stats

52.88. pg_tables

52.89. pg_timezone_abbrevs

52.90. pg_timezone_names

52.91. pg_user

52.92. pg_user_mappings

52.93. pg_views

系统目录是关系型数据库存放模式元数据的地方，比如表和列的信息，以及内部统计信息等。PostgreSQL的系统目录就是普通表。你可以删除并重建这些表、增加列、插入和更新数值， 然后彻底把你的系统搞垮。 通常情况下，我们不应该手工修改系统目录，通常有SQL命令可以做这些事情。（例如，CREATE DATABASE向 pg_database表插入一行 — 并且实际上在磁盘上创建该数据库。）。 有几种特别深奥的操作例外，但是随着时间的流逝其中的很多也可以用 SQL 命令来完成，因此对系统目录直接修改的需求也越来越小。