↑↓ 选择 ↵ 打开 ⌫ 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。

受支持版本： 当前版本 (18) / 17 / 16 / 15 / 14
测试与开发版本： 19 / devel
不受支持的版本： 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0
历史版本PostgreSQL 9.2 已于 2017 年 11 月结束社区维护，本页译文保留供仍在使用旧版本的读者参考。新系统请看当前版本。
第 45 章 系统目录
上一页  上一级 部分 VII. 内部 起始页  下一页

第 45 章 系统目录

目录

45.1. 概述
45.2. pg_aggregate
45.3. pg_am
45.4. pg_amop
45.5. pg_amproc
45.6. pg_attrdef
45.7. pg_attribute
45.8. pg_authid
45.9. pg_auth_members
45.10. pg_cast
45.11. pg_class
45.12. pg_constraint
45.13. pg_collation
45.14. pg_conversion
45.15. pg_database
45.16. pg_db_role_setting
45.17. pg_default_acl
45.18. pg_depend
45.19. pg_description
45.20. pg_enum
45.21. pg_extension
45.22. pg_foreign_data_wrapper
45.23. pg_foreign_server
45.24. pg_foreign_table
45.25. pg_index
45.26. pg_inherits
45.27. pg_language
45.28. pg_largeobject
45.29. pg_largeobject_metadata
45.30. pg_namespace
45.31. pg_opclass
45.32. pg_operator
45.33. pg_opfamily
45.34. pg_pltemplate
45.35. pg_proc
45.36. pg_range
45.37. pg_rewrite
45.38. pg_seclabel
45.39. pg_shdepend
45.40. pg_shdescription
45.41. pg_shseclabel
45.42. pg_statistic
45.43. pg_tablespace
45.44. pg_trigger
45.45. pg_ts_config
45.46. pg_ts_config_map
45.47. pg_ts_dict
45.48. pg_ts_parser
45.49. pg_ts_template
45.50. pg_type
45.51. pg_user_mapping
45.52. 系统视图
45.53. pg_available_extensions
45.54. pg_available_extension_versions
45.55. pg_cursors
45.56. pg_group
45.57. pg_indexes
45.58. pg_locks
45.59. pg_prepared_statements
45.60. pg_prepared_xacts
45.61. pg_roles
45.62. pg_rules
45.63. pg_seclabels
45.64. pg_settings
45.65. pg_shadow
45.66. pg_stats
45.67. pg_tables
45.68. pg_timezone_abbrevs
45.69. pg_timezone_names
45.70. pg_user
45.71. pg_user_mappings
45.72. pg_views

系统目录是关系型数据库管理系统存放模式元数据的地方，例如表和列的信息以及内部记账信息。PostgreSQL 的系统目录是普通表。你可以删除并重建这些表、增加列、插入和更新数值，并借此把系统严重搞坏。通常，不应手工修改系统目录，总是有 SQL 命令可用于完成这些操作。（例如，CREATE DATABASE 会向 pg_database 目录中插入一行 — 并且实际上会在磁盘上创建该数据库。）对于某些特别深奥的操作存在一些例外，例如增加索引访问方法。

45.1. 概述 #

表 45.1列出了系统目录。每个目录更详细的文档见后文。

大多数系统目录在创建数据库时都会从模板数据库复制过来，因此之后是数据库专有的。少数目录在物理上由一个集簇中的所有数据库共享；这些目录会在各自的说明中注明。

表 45.1. 系统目录

Catalog Name Purpose
pg_aggregate aggregate functions
pg_am index access methods
pg_amop access method operators
pg_amproc access method support procedures
pg_attrdef column default values
pg_attribute table columns (“attributes”)
pg_authid authorization identifiers (roles)
pg_auth_members authorization identifier membership relationships
pg_cast casts (data type conversions)
pg_class tables, indexes, sequences, views (“relations”)
pg_constraint check constraints, unique constraints, primary key constraints, foreign key constraints
pg_collation collations (locale information)
pg_conversion encoding conversion information
pg_database databases within this database cluster
pg_db_role_setting per-role and per-database settings
pg_default_acl default privileges for object types
pg_depend dependencies between database objects
pg_description descriptions or comments on database objects
pg_enum enum label and value definitions
pg_extension installed extensions
pg_foreign_data_wrapper foreign-data wrapper definitions
pg_foreign_server foreign server definitions
pg_foreign_table additional foreign table information
pg_index additional index information
pg_inherits table inheritance hierarchy
pg_language languages for writing functions
pg_largeobject data pages for large objects
pg_largeobject_metadata metadata for large objects
pg_namespace schemas
pg_opclass access method operator classes
pg_operator operators
pg_opfamily access method operator families
pg_pltemplate template data for procedural languages
pg_proc functions and procedures
pg_range 范围类型的信息
pg_rewrite query rewrite rules
pg_seclabel security labels on database objects
pg_shdepend dependencies on shared objects
pg_shdescription comments on shared objects
pg_shseclabel 共享数据库对象上的安全标签
pg_statistic planner statistics
pg_tablespace tablespaces within this database cluster
pg_trigger triggers
pg_ts_config text search configurations
pg_ts_config_map text search configurations' token mappings
pg_ts_dict text search dictionaries
pg_ts_parser text search parsers
pg_ts_template text search templates
pg_type data types
pg_user_mapping mappings of users to foreign servers

上一页  上一级  下一页
44.6. 执行器  起始页  45.2. pg_aggregate

提交更正

译文有误、术语不当或页面显示问题，请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题，请在当前版本的对应页面向上游反馈；上游不再修订已结束维护的版本。