PG系統目錄

wongchaofan發表於2024-05-26

Table of Contents50.1. Overview

Catalog NamePurpose
pg_aggregate 聚合函式
pg_am 索引訪問方法
pg_amop 訪問方法運算子
pg_amproc 訪問方法支援程式
pg_attrdef 列預設值
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_collation collations (locale information)排序規則(區域資訊)
pg_constraint

check constraints, unique constraints, primary key constraints, foreign key constraints

檢查約束、唯一約束、主鍵約束、外來鍵約束

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_event_trigger event triggers事件觸發器
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_init_privs object initial privileges物件初始許可權
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_policy row-security policies行安全策略
pg_proc functions and procedures職能和程式
pg_range information about range types有關範圍型別的資訊
pg_replication_origin registered replication origins註冊複製起點

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 security labels on shared database objects共享資料庫物件上的安全標籤
pg_statistic planner statistics計劃統計
pg_tablespace tablespaces within this database cluster此資料庫叢集內的表空間
pg_transform transforms (data type to procedural language conversions)轉換(資料型別到過程語言的轉換)
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使用者到外部伺服器的對映

50.2. pg_aggregate

50.3. pg_am

50.4. pg_amop

50.5. pg_amproc

50.6. pg_attrdef

50.7. pg_attribute

50.8. pg_authid

50.9. pg_auth_members

50.10. pg_cast

50.11. pg_class

50.12. pg_collation

50.13. pg_constraint

50.14. pg_conversion

50.15. pg_database

50.16. pg_db_role_setting

50.17. pg_default_acl

50.18. pg_depend

50.19. pg_description

50.20. pg_enum

50.21. pg_event_trigger

50.22. pg_extension

50.23. pg_foreign_data_wrapper

50.24. pg_foreign_server

50.25. pg_foreign_table

50.26. pg_index

50.27. pg_inherits

50.28. pg_init_privs

50.29. pg_language

50.30. pg_largeobject

50.31. pg_largeobject_metadata

50.32. pg_namespace

50.33. pg_opclass

50.34. pg_operator

50.35. pg_opfamily

50.36. pg_pltemplate

50.37. pg_policy

50.38. pg_proc

50.39. pg_range

50.40. pg_replication_origin

50.41. pg_rewrite

50.42. pg_seclabel

50.43. pg_shdepend

50.44. pg_shdescription

50.45. pg_shseclabel

50.46. pg_statistic

50.47. pg_tablespace

50.48. pg_transform

50.49. pg_trigger

50.50. pg_ts_config

50.51. pg_ts_config_map

50.52. pg_ts_dict

50.53. pg_ts_parser

50.54. pg_ts_template

50.55. pg_type

50.56. pg_user_mapping

50.57. System Views

50.58. pg_available_extensions

50.59. pg_available_extension_versions

50.60. pg_config

50.61. pg_cursors

50.62. pg_file_settings

50.63. pg_group

50.64. pg_indexes

50.65. pg_locks

50.66. pg_matviews

50.67. pg_policies

50.68. pg_prepared_statements

50.69. pg_prepared_xacts

50.70. pg_replication_origin_status

50.71. pg_replication_slots

50.72. pg_roles

50.73. pg_rules

50.74. pg_seclabels

50.75. pg_settings

50.76. pg_shadow

50.77. pg_stats

50.78. pg_tables

50.79. pg_timezone_abbrevs

50.80. pg_timezone_names

50.81. pg_user

50.82. pg_user_mappings

50.83. pg_views

相關文章