Redrock Postgres 搜索 英文
版本: 9.3 / 9.4 / 9.5 / 9.6 / 10 / 11 / 12 / 13 / 14 / 15 / 16 / 17

第 51 章. 系统目录

目录

51.1. 概述
51.2. pg_aggregate
51.3. pg_am
51.4. pg_amop
51.5. pg_amproc
51.6. pg_attrdef
51.7. pg_attribute
51.8. pg_authid
51.9. pg_auth_members
51.10. pg_cast
51.11. pg_class
51.12. pg_collation
51.13. pg_constraint
51.14. pg_conversion
51.15. pg_database
51.16. pg_db_role_setting
51.17. pg_default_acl
51.18. pg_depend
51.19. pg_description
51.20. pg_enum
51.21. pg_event_trigger
51.22. pg_extension
51.23. pg_foreign_data_wrapper
51.24. pg_foreign_server
51.25. pg_foreign_table
51.26. pg_index
51.27. pg_inherits
51.28. pg_init_privs
51.29. pg_language
51.30. pg_largeobject
51.31. pg_largeobject_metadata
51.32. pg_namespace
51.33. pg_opclass
51.34. pg_operator
51.35. pg_opfamily
51.36. pg_parameter_acl
51.37. pg_partitioned_table
51.38. pg_policy
51.39. pg_proc
51.40. pg_publication
51.41. pg_publication_namespace
51.42. pg_publication_rel
51.43. pg_range
51.44. pg_replication_origin
51.45. pg_rewrite
51.46. pg_seclabel
51.47. pg_sequence
51.48. pg_shdepend
51.49. pg_shdescription
51.50. pg_shseclabel
51.51. pg_statistic
51.52. pg_statistic_ext
51.53. pg_statistic_ext_data
51.54. pg_subscription
51.55. pg_subscription_rel
51.56. pg_tablespace
51.57. pg_transform
51.58. pg_trigger
51.59. pg_ts_config
51.60. pg_ts_config_map
51.61. pg_ts_dict
51.62. pg_ts_parser
51.63. pg_ts_template
51.64. pg_type
51.65. pg_user_mapping

系统目录是关系数据库管理系统存储架构元数据的区域,其中包括关于表和列的信息和内部记账信息。PostgreSQL 的系统目录是常规表。您可以删除和重新创建表,添加列,插入和更新值,并且会以这种方式严重搞乱您的系统。通常,应该手动更改系统目录,通常有 SQL 命令来执行此操作。(例如,CREATE DATABASE 将一行插入到 pg_database 目录中,并实际在磁盘上创建数据库。)对于一些奇异的操作有一些例外,但其中一些操作已于随时间成为 SQL 命令可用,因此,直接处理系统目录的需求在不断减少。