简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Verzeichnis suchen

前言何为PostgreSQL？ PostgreSQL简史格式约定更多信息臭虫汇报指导 I. 教程章1. 从头开始 1.1. 安装 1.2. 体系基本概念 1.3. 创建一个数据库 1.4. 访问数据库章2. SQL语言 2.1. 介绍 2.2. 概念 2.3. 创建新表 2.4. 向表中添加行 2.5. 查询一个表 2.6. 表间链接 2.7. 聚集函数 2.8. 更新 2.9. 删除章3. 高级特性 3.1. 介绍 3.2. 视图 3.3. 外键 3.4. 事务 3.5. 窗口函数 3.6. 继承 3.7. 结论 II. SQL语言章4. SQL语法 4.1. 词法结构 4.2. 值表达式 4.3. 调用函数章5. 数据定义 5.1. 表的基本概念 5.2. 缺省值 5.3. 约束 5.4. 系统字段 5.5. 修改表 5.6. 权限 5.7. 模式 5.8. 继承 5.9. 分区 5.10. 其它数据库对象 5.11. 依赖性跟踪章 6. 数据操作 6.1. 插入数据 6.2. 更新数据 6.3. 删除数据章7. 查询 7.1. 概述 7.2. 表表达式 7.3. 选择列表 7.4. 组合查询 7.5. 行排序 7.6. LIMIT和OFFSET 7.7. VALUES列表 7.8. WITH的查询（公用表表达式）章8. 数据类型 8.1. 数值类型 8.2. 货币类型 8.3. 字符类型 8.4. 二进制数据类型 8.5. 日期/时间类型 8.6. 布尔类型 8.7. 枚举类型 8.8. 几何类型 8.9. 网络地址类型 8.10. 位串类型 8.11. 文本搜索类型 8.12. UUID类型 8.13. XML类型 8.14. 数组 8.15. 复合类型 8.16. 对象标识符类型 8.17. 伪类型章 9. 函数和操作符 9.1. 逻辑操作符 9.2. 比较操作符 9.3. 数学函数和操作符 9.4. 字符串函数和操作符 9.5. 二进制字符串函数和操作符 9.6. 位串函数和操作符 9.7. 模式匹配 9.8. 数据类型格式化函数 9.9. 时间/日期函数和操作符 9.10. 支持枚举函数 9.11. 几何函数和操作符 9.12. 网络地址函数和操作符 9.13. 文本检索函数和操作符 9.14. XML函数 9.15. 序列操作函数 9.16. 条件表达式 9.17. 数组函数和操作符 9.18. 聚合函数 9.19. 窗口函数 9.20. 子查询表达式 9.21. 行和数组比较 9.22. 返回集合的函数 9.23. 系统信息函数 9.24. 系统管理函数 9.25. 触发器函数章10. 类型转换 10.3. 函数 10.2. 操作符 10.1. 概述 10.4. 值存储 10.5. UNION 章11. 索引 11.1. 介绍 11.2. 索引类型 11.3. 多字段索引 11.4. 索引和ORDER BY 11.5. 组合多个索引 11.6. 唯一索引 11.7. 表达式上的索引 11.8. 部分索引 11.9. 操作类和操作簇 11.10. 检查索引的使用章12. Full Text Search 12.1. Introduction 12.2. Tables and Indexes 12.3. Controlling Text Search 12.4. Additional Features 12.5. Parsers 12.6. Dictionaries 12.7. Configuration Example 12.8. Testing and Debugging Text Search 12.9. GiST and GIN Index Types 12.10. psql Support 12.11. Limitations 12.12. Migration from Pre-8.3 Text Search 章13. 并发控制 13.1. 介绍 13.2. 事务隔离 13.3. 明确锁定 13.4. 应用层数据完整性检查 13.5. 锁和索引章14. 性能提升技巧 14.1. 使用EXPLAIN 14.2. 规划器使用的统计信息 14.3. 用明确的JOIN语句控制规划器 14.4. 向数据库中添加记录 14.5. 非持久性设置 III. 服务器管理章15. 安装指导 15.1. 简版 15.2. 要求 15.3. 获取源码 15.4. 升级 15.5. 安装过程 15.6. 安装后的设置 15.7. 支持的平台 15.8. 特殊平台的要求章16. Installation from Source Code on Windows 16.1. Building with Visual C++ or the Platform SDK 16.2. Building libpq with Visual C++ or Borland C++ 章17. 服务器安装和操作 17.1. PostgreSQL用户帐户 17.2. 创建数据库集群 17.3. 启动数据库服务器 17.4. 管理内核资源 17.5. 关闭服务 17.6. 防止服务器欺骗 17.7. 加密选项 17.8. 用SSL进行安全的TCP/IP连接 17.9. Secure TCP/IP Connections with SSH Tunnels 章18. 服务器配置 18.1. 设置参数 18.2. 文件位置 18.3. 连接和认证 18.4. 资源消耗 18.5. 预写式日志 18.6. 查询规划 18.7. 错误报告和日志 18.8. 运行时统计 18.9. 自动清理 18.10. 客户端连接缺省 18.12. 版本和平台兼容性 18.11. 锁管理 18.13. 预置选项 18.14. 自定义的选项 18.15. 开发人员选项 18.16. 短选项章19. 用户认证 19.1. pg_hba.conf 文件 19.2. 用户名映射 19.3. 认证方法 19.4. 用户认证章20. 数据库角色和权限 20.1. 数据库角色 20.2. 角色属性 20.3. 权限 20.4. 角色成员 20.5. 函数和触发器章21. 管理数据库 21.1. 概述 21.2. 创建一个数据库 21.3. 临时库 21.4. 数据库配置 21.5. 删除数据库 21.6. 表空间章22. 本土化 22.1. 区域支持 22.2. 字符集支持章23. 日常数据库维护工作 23.1. Routine Vacuuming日常清理 23.2. 经常重建索引 23.3. 日志文件维护章24. 备份和恢复 24.1. SQL转储 24.2. 文件系统级别的备份 24.3. 在线备份以及即时恢复(PITR) 24.4. 版本间迁移章25. 高可用性与负载均衡，复制 25.1. 不同解决方案的比较 25.2. 日志传送备份服务器 25.3. 失效切换 25.4. 日志传送的替代方法 25.5. 热备章26. 恢复配置 26.1. 归档恢复设置 26.2. 恢复目标设置 26.3. 备服务器设置章27. 监控数据库的活动 27.1. 标准Unix工具 27.2. 统计收集器 27.3. 查看锁 27.4. 动态跟踪章28. 监控磁盘使用情况 28.1. 判断磁盘的使用量 28.2. 磁盘满导致的失效章29. 可靠性和预写式日志 29.1. 可靠性 29.2. 预写式日志(WAL) 29.3. 异步提交 29.4. WAL配置 29.5. WAL内部章30. Regression Tests 30.1. Running the Tests 30.2. Test Evaluation 30.3. Variant Comparison Files 30.4. Test Coverage Examination IV. 客户端接口章31. libpq-C库 31.1. 数据库联接函数 31.2. 连接状态函数 31.3. 命令执行函数 31.4. 异步命令处理 31.5. 取消正在处理的查询 31.6. 捷径接口 31.7. 异步通知 31.8. 与COPY命令相关的函数 31.9. Control Functions 控制函数 31.10. 其他函数 31.11. 注意信息处理 31.12. 事件系统 31.13. 环境变量 31.14. 口令文件 31.15. 连接服务的文件 31.16. LDAP查找连接参数 31.17. SSL支持 31.18. 在多线程程序里的行为 31.19. 制作libpq程序 31.20. 例子程序章32. 大对象 32.1. 介绍 32.2. 实现特点 32.3. 客户端接口 32.4. 服务器端函数 32.5. 例子程序章33. ECPG - Embedded SQL in C 33.1. The Concept 33.2. Connecting to the Database Server 33.3. Closing a Connection 33.4. Running SQL Commands 33.5. Choosing a Connection 33.6. Using Host Variables 33.7. Dynamic SQL 33.8. pgtypes library 33.9. Using Descriptor Areas 33.10. Informix compatibility mode 33.11. Error Handling 33.12. Preprocessor directives 33.13. Processing Embedded SQL Programs 33.14. Library Functions 33.15. Internals 章34. 信息模式 34.1. 关于这个模式 34.2. 数据类型 34.3. information_schema_catalog_name 34.4. administrable_role_authorizations 34.5. applicable_roles 34.6. attributes 34.7. check_constraint_routine_usage 34.8. check_constraints 34.9. column_domain_usage 34.10. column_privileges 34.11. column_udt_usage 34.12. 字段 34.13. constraint_column_usage 34.14. constraint_table_usage 34.15. data_type_privileges 34.16. domain_constraints 34.18. domains 34.17. domain_udt_usage 34.19. element_types 34.20. enabled_roles 34.21. foreign_data_wrapper_options 34.22. foreign_data_wrappers 34.23. foreign_server_options 34.24. foreign_servers 34.25. key_column_usage 34.26. parameters 34.27. referential_constraints 34.28. role_column_grants 34.29. role_routine_grants 34.30. role_table_grants 34.31. role_usage_grants 34.32. routine_privileges 34.33. routines 34.34. schemata 34.35. sequences 34.36. sql_features 34.37. sql_implementation_info 34.38. sql_languages 34.39. sql_packages 34.40. sql_parts 34.41. sql_sizing 34.42. sql_sizing_profiles 34.43. table_constraints 34.44. table_privileges 34.45. tables 34.46. triggered_update_columns 34.47. 触发器 34.48. usage_privileges 34.49. user_mapping_options 34.50. user_mappings 34.51. view_column_usage 34.52. view_routine_usage 34.53. view_table_usage 34.54. 视图 V. 服务器端编程章35. 扩展SQL 35.1. 扩展性是如何实现的 35.2. PostgreSQL类型系统 35.3. User-Defined Functions 35.4. Query Language (SQL) Functions 35.5. Function Overloading 35.6. Function Volatility Categories 35.7. Procedural Language Functions 35.8. Internal Functions 35.9. C-Language Functions 35.10. User-Defined Aggregates 35.11. User-Defined Types 35.12. User-Defined Operators 35.13. Operator Optimization Information 35.14. Interfacing Extensions To Indexes 35.15. 用C++扩展章36. 触发器 36.1. 触发器行为概述 36.3. 用 C 写触发器 36.2. 数据改变的可视性 36.4. 一个完整的例子章37. 规则系统 37.1. The Query Tree 37.2. 视图和规则系统 37.3. 在INSERT，UPDATE和DELETE上的规则 37.4. 规则和权限 37.5. 规则和命令状态 37.6. 规则与触发器得比较章38. Procedural Languages 38.1. Installing Procedural Languages 章39. PL/pgSQL - SQL过程语言 39.1. 概述 39.2. PL/pgSQL的结构 39.3. 声明 39.4. 表达式 39.5. 基本语句 39.6. 控制结构 39.7. 游标 39.8. 错误和消息 39.9. 触发器过程 39.10. PL/pgSQL Under the Hood 39.11. 开发PL/pgSQL的一些提示 39.12. 从OraclePL/SQL 进行移植章40. PL/Tcl - Tcl Procedural Language 40.1. Overview 40.2. PL/Tcl Functions and Arguments 40.3. Data Values in PL/Tcl 40.4. Global Data in PL/Tcl 40.5. Database Access from PL/Tcl 40.6. Trigger Procedures in PL/Tcl 40.7. Modules and the unknown command 40.8. Tcl Procedure Names 章41. PL/Perl - Perl Procedural Language 41.1. PL/Perl Functions and Arguments 41.2. Data Values in PL/Perl 41.3. Built-in Functions 41.4. Global Values in PL/Perl 41.6. PL/Perl Triggers 41.5. Trusted and Untrusted PL/Perl 41.7. PL/Perl Under the Hood 章42. PL/Python - Python Procedural Language 42.1. Python 2 vs. Python 3 42.2. PL/Python Functions 42.3. Data Values 42.4. Sharing Data 42.5. Anonymous Code Blocks 42.6. Trigger Functions 42.7. Database Access 42.8. Utility Functions 42.9. Environment Variables 章43. Server Programming Interface 43.1. Interface Functions Spi-spi-connect Spi-spi-finish Spi-spi-push Spi-spi-pop Spi-spi-execute Spi-spi-exec Spi-spi-execute-with-args Spi-spi-prepare Spi-spi-prepare-cursor Spi-spi-prepare-params Spi-spi-getargcount Spi-spi-getargtypeid Spi-spi-is-cursor-plan Spi-spi-execute-plan Spi-spi-execute-plan-with-paramlist Spi-spi-execp Spi-spi-cursor-open Spi-spi-cursor-open-with-args Spi-spi-cursor-open-with-paramlist Spi-spi-cursor-find Spi-spi-cursor-fetch Spi-spi-cursor-move Spi-spi-scroll-cursor-fetch Spi-spi-scroll-cursor-move Spi-spi-cursor-close Spi-spi-saveplan 43.2. Interface Support Functions Spi-spi-fname Spi-spi-fnumber Spi-spi-getvalue Spi-spi-getbinval Spi-spi-gettype Spi-spi-gettypeid Spi-spi-getrelname Spi-spi-getnspname 43.3. Memory Management Spi-spi-palloc Spi-realloc Spi-spi-pfree Spi-spi-copytuple Spi-spi-returntuple Spi-spi-modifytuple Spi-spi-freetuple Spi-spi-freetupletable Spi-spi-freeplan 43.4. Visibility of Data Changes 43.5. Examples VI. 参考手册 I. SQL命令 Sql-abort Sql-alteraggregate Sql-alterconversion Sql-alterdatabase Sql-alterdefaultprivileges Sql-alterdomain Sql-alterforeigndatawrapper Sql-alterfunction Sql-altergroup Sql-alterindex Sql-alterlanguage Sql-alterlargeobject Sql-alteroperator Sql-alteropclass Sql-alteropfamily Sql-alterrole Sql-alterschema Sql-altersequence Sql-alterserver Sql-altertable Sql-altertablespace Sql-altertsconfig Sql-altertsdictionary Sql-altertsparser Sql-altertstemplate Sql-altertrigger Sql-altertype Sql-alteruser Sql-alterusermapping Sql-alterview Sql-analyze Sql-begin Sql-checkpoint Sql-close Sql-cluster Sql-comment Sql-commit Sql-commit-prepared Sql-copy Sql-createaggregate Sql-createcast Sql-createconstraint Sql-createconversion Sql-createdatabase Sql-createdomain Sql-createforeigndatawrapper Sql-createfunction Sql-creategroup Sql-createindex Sql-createlanguage Sql-createoperator Sql-createopclass Sql-createopfamily Sql-createrole Sql-createrule Sql-createschema Sql-createsequence Sql-createserver Sql-createtable Sql-createtableas Sql-createtablespace Sql-createtsconfig Sql-createtsdictionary Sql-createtsparser Sql-createtstemplate Sql-createtrigger Sql-createtype Sql-createuser Sql-createusermapping Sql-createview Sql-deallocate Sql-declare Sql-delete Sql-discard Sql-do Sql-dropaggregate Sql-dropcast Sql-dropconversion Sql-dropdatabase Sql-dropdomain Sql-dropforeigndatawrapper Sql-dropfunction Sql-dropgroup Sql-dropindex Sql-droplanguage Sql-dropoperator Sql-dropopclass Sql-dropopfamily Sql-drop-owned Sql-droprole Sql-droprule Sql-dropschema Sql-dropsequence Sql-dropserver Sql-droptable Sql-droptablespace Sql-droptsconfig Sql-droptsdictionary Sql-droptsparser Sql-droptstemplate Sql-droptrigger Sql-droptype Sql-dropuser Sql-dropusermapping Sql-dropview Sql-end Sql-execute Sql-explain Sql-fetch Sql-grant Sql-insert Sql-listen Sql-load Sql-lock Sql-move Sql-notify Sql-prepare Sql-prepare-transaction Sql-reassign-owned Sql-reindex Sql-release-savepoint Sql-reset Sql-revoke Sql-rollback Sql-rollback-prepared Sql-rollback-to Sql-savepoint Sql-select Sql-selectinto Sql-set Sql-set-constraints Sql-set-role Sql-set-session-authorization Sql-set-transaction Sql-show Sql-start-transaction Sql-truncate Sql-unlisten Sql-update Sql-vacuum Sql-values II. 客户端应用程序 App-clusterdb App-createdb App-createlang App-createuser App-dropdb App-droplang App-dropuser App-ecpg App-pgconfig App-pgdump App-pg-dumpall App-pgrestore App-psql App-reindexdb App-vacuumdb III. PostgreSQL服务器应用程序 App-initdb App-pgcontroldata App-pg-ctl App-pgresetxlog App-postgres App-postmaster VII. 内部章44. PostgreSQL内部概览 44.1. 查询路径 44.2. 连接是如何建立起来的 44.3. 分析器阶段 44.4. ThePostgreSQL规则系统 44.5. 规划器/优化器 44.6. 执行器章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_conversion 45.14. pg_database 45.15. pg_db_role_setting 45.16. pg_default_acl 45.17. pg_depend 45.18. pg_description 45.19. pg_enum 45.20. pg_foreign_data_wrapper 45.21. pg_foreign_server 45.22. pg_index 45.23. pg_inherits 45.24. pg_language 45.25. pg_largeobject 45.26. pg_largeobject_metadata 45.27. pg_namespace 45.28. pg_opclass 45.29. pg_operator 45.30. pg_opfamily 45.31. pg_pltemplate 45.32. pg_proc 45.33. pg_rewrite 45.34. pg_shdepend 45.35. pg_shdescription 45.36. pg_statistic 45.37. pg_tablespace 45.38. pg_trigger 45.39. pg_ts_config 45.40. pg_ts_config_map 45.41. pg_ts_dict 45.42. pg_ts_parser 45.43. pg_ts_template 45.44. pg_type 45.45. pg_user_mapping 45.46. System Views 45.47. pg_cursors 45.48. pg_group 45.49. pg_indexes 45.50. pg_locks 45.51. pg_prepared_statements 45.52. pg_prepared_xacts 45.53. pg_roles 45.54. pg_rules 45.55. pg_settings 45.56. pg_shadow 45.57. pg_stats 45.58. pg_tables 45.59. pg_timezone_abbrevs 45.60. pg_timezone_names 45.61. pg_user 45.62. pg_user_mappings 45.63. pg_views 章46. Frontend/Backend Protocol 46.1. Overview 46.2. Message Flow 46.3. Streaming Replication Protocol 46.4. Message Data Types 46.5. Message Formats 46.6. Error and Notice Message Fields 46.7. Summary of Changes since Protocol 2.0 47. PostgreSQL Coding Conventions 47.1. Formatting 47.2. Reporting Errors Within the Server 47.3. Error Message Style Guide 章48. Native Language Support 48.1. For the Translator 48.2. For the Programmer 章49. Writing A Procedural Language Handler 章50. Genetic Query Optimizer 50.1. Query Handling as a Complex Optimization Problem 50.2. Genetic Algorithms 50.3. Genetic Query Optimization (GEQO) in PostgreSQL 50.4. Further Reading 章51. 索引访问方法接口定义 51.1. 索引的系统表记录 51.2. 索引访问方法函数 51.3. 索引扫描 51.4. 索引锁的考量 51.5. 索引唯一性检查 51.6. 索引开销估计函数章52. GiST Indexes 52.1. Introduction 52.2. Extensibility 52.3. Implementation 52.4. Examples 52.5. Crash Recovery 章53. GIN Indexes 53.1. Introduction 53.2. Extensibility 53.3. Implementation 53.4. GIN tips and tricks 53.5. Limitations 53.6. Examples 章54. 数据库物理存储 54.1. 数据库文件布局 54.2. TOAST 54.3. 自由空间映射 54.4. 可见映射 54.5. 数据库分页文件章55. BKI后端接口 55.1. BKI 文件格式 55.2. BKI命令 55.3. 系统初始化的BKI文件的结构 55.4. 例子章56. 规划器如何使用统计信息 56.1. 行预期的例子 VIII. 附录 A. PostgreSQL错误代码 B. 日期/时间支持 B.1. 日期/时间输入解析 B.2. 日期/时间关键字 B.3. 日期/时间配置文件 B.4. 日期单位的历史 C. SQL关键字 D. SQL Conformance D.1. Supported Features D.2. Unsupported Features E. Release Notes Release-0-01 Release-0-02 Release-0-03 Release-1-0 Release-1-01 Release-1-02 Release-1-09 Release-6-0 Release-6-1 Release-6-1-1 Release-6-2 Release-6-2-1 Release-6-3 Release-6-3-1 Release-6-3-2 Release-6-4 Release-6-4-1 Release-6-4-2 Release-6-5 Release-6-5-1 Release-6-5-2 Release-6-5-3 Release-7-0 Release-7-0-1 Release-7-0-2 Release-7-0-3 Release-7-1 Release-7-1-1 Release-7-1-2 Release-7-1-3 Release-7-2 Release-7-2-1 Release-7-2-2 Release-7-2-3 Release-7-2-4 Release-7-2-5 Release-7-2-6 Release-7-2-7 Release-7-2-8 Release-7-3 Release-7-3-1 Release-7-3-10 Release-7-3-11 Release-7-3-12 Release-7-3-13 Release-7-3-14 Release-7-3-15 Release-7-3-16 Release-7-3-17 Release-7-3-18 Release-7-3-19 Release-7-3-2 Release-7-3-20 Release-7-3-21 Release-7-3-3 Release-7-3-4 Release-7-3-5 Release-7-3-6 Release-7-3-7 Release-7-3-8 Release-7-3-9 Release-7-4 Release-7-4-1 Release-7-4-10 Release-7-4-11 Release-7-4-12 Release-7-4-13 Release-7-4-14 Release-7-4-15 Release-7-4-16 Release-7-4-17 Release-7-4-18 Release-7-4-19 Release-7-4-2 Release-7-4-20 Release-7-4-21 Release-7-4-22 Release-7-4-23 Release-7-4-24 Release-7-4-25 Release-7-4-26 Release-7-4-27 Release-7-4-28 Release-7-4-29 Release-7-4-3 Release-7-4-30 Release-7-4-4 Release-7-4-5 Release-7-4-6 Release-7-4-7 Release-7-4-8 Release-7-4-9 Release-8-0 Release-8-0-1 Release-8-0-10 Release-8-0-11 Release-8-0-12 Release-8-0-13 Release-8-0-14 Release-8-0-15 Release-8-0-16 Release-8-0-17 Release-8-0-18 Release-8-0-19 Release-8-0-2 Release-8-0-20 Release-8-0-21 Release-8-0-22 Release-8-0-23 Release-8-0-24 Release-8-0-25 Release-8-0-26 Release-8-0-3 Release-8-0-4 Release-8-0-5 Release-8-0-6 Release-8-0-7 Release-8-0-8 Release-8-0-9 Release-8-1 Release-8-1-1 Release-8-1-10 Release-8-1-11 Release-8-1-12 Release-8-1-13 Release-8-1-14 Release-8-1-15 Release-8-1-16 Release-8-1-17 Release-8-1-18 Release-8-1-19 Release-8-1-2 Release-8-1-20 Release-8-1-21 Release-8-1-22 Release-8-1-23 Release-8-1-3 Release-8-1-4 Release-8-1-5 Release-8-1-6 Release-8-1-7 Release-8-1-8 Release-8-1-9 Release-8-2 Release-8-2-1 Release-8-2-10 Release-8-2-11 Release-8-2-12 Release-8-2-13 Release-8-2-14 Release-8-2-15 Release-8-2-16 Release-8-2-17 Release-8-2-18 Release-8-2-19 Release-8-2-2 Release-8-2-20 Release-8-2-21 Release-8-2-3 Release-8-2-4 Release-8-2-5 Release-8-2-6 Release-8-2-7 Release-8-2-8 Release-8-2-9 Release-8-3 Release-8-3-1 Release-8-3-10 Release-8-3-11 Release-8-3-12 Release-8-3-13 Release-8-3-14 Release-8-3-15 Release-8-3-2 Release-8-3-3 Release-8-3-4 Release-8-3-5 Release-8-3-6 Release-8-3-7 Release-8-3-8 Release-8-3-9 Release-8-4 Release-8-4-1 Release-8-4-2 Release-8-4-3 Release-8-4-4 Release-8-4-5 Release-8-4-6 Release-8-4-7 Release-8-4-8 Release-9-0 Release-9-0-1 Release-9-0-2 Release-9-0-3 Release-9-0-4 F. 额外提供的模块 F.1. adminpack F.2. auto_explain F.3. btree_gin F.4. btree_gist F.5. chkpass F.6. citext F.7. cube F.8. dblink Contrib-dblink-connect Contrib-dblink-connect-u Contrib-dblink-disconnect Contrib-dblink Contrib-dblink-exec Contrib-dblink-open Contrib-dblink-fetch Contrib-dblink-close Contrib-dblink-get-connections Contrib-dblink-error-message Contrib-dblink-send-query Contrib-dblink-is-busy Contrib-dblink-get-notify Contrib-dblink-get-result Contrib-dblink-cancel-query Contrib-dblink-get-pkey Contrib-dblink-build-sql-insert Contrib-dblink-build-sql-delete Contrib-dblink-build-sql-update F.9. dict_int F.10. dict_xsyn F.11. earthdistance F.12. fuzzystrmatch F.13. hstore F.14. intagg F.15. intarray F.16. isn F.17. lo F.18. ltree F.19. oid2name F.20. pageinspect F.21. passwordcheck F.22. pg_archivecleanup F.23. pgbench F.24. pg_buffercache F.25. pgcrypto F.26. pg_freespacemap F.27. pgrowlocks F.28. pg_standby F.29. pg_stat_statements F.30. pgstattuple F.31. pg_trgm F.32. pg_upgrade F.33. seg F.34. spi F.35. sslinfo F.36. tablefunc F.37. test_parser F.38. tsearch2 F.39. unaccent F.40. uuid-ossp F.41. vacuumlo F.42. xml2 G. 外部项目 G.1. 客户端接口 G.2. 过程语言 G.3. 扩展 H. The Source Code Repository H.1. Getting The Source Via Git I. 文档 I.1. DocBook I.2. 工具集 I.3. 制作文档 I.4. 文档写作 I.5. 风格指导 J. 首字母缩略词参考书目 Bookindex Index

Figuren

Index

Symbols

$, Positional Parameters

$libdir, Dynamic Loading

$libdir/plugins, Other Defaults, Description

*, Select-List Items

.pgpass, The Password File

.pg_service.conf, The Connection Service File

::, Type Casts

_PG_fini, Dynamic Loading

_PG_init, Dynamic Loading

版本

兼容性, 版本间迁移

备份, 备份和恢复

本地化, 区域支持

表, 表的基本概念

创建, 表的基本概念

分区, 分区

继承, 继承

删除, 表的基本概念

修改, 修改表

重命名, 重命名表

参照完整性, 外键

插入, 插入数据

超级用户, 角色属性

窗口函数, 窗口函数

非空约束, 非空约束

分区, 分区

更新, 更新数据

过程语言

外部维护, 过程语言

即时恢复, 备份和恢复

级联

用 DROP, 依赖性跟踪

外键作用, 外键

继承, 继承

检查约束, 检查约束

角色, 数据库角色

privilege to create, 角色属性

接口

外部维护, 客户端接口

空值

检查约束, 检查约束

唯一约束, 唯一约束

口令, 角色属性

扩展, 扩展

列, 表的基本概念

名字

受修饰的, 创建模式

未修饰的, 模式搜索路径

模式, 模式

public, 模式

创建, 创建模式

当前, 模式搜索路径

删除, 创建模式

排除约束, 排除约束

权限, 权限, 权限

模式, 模式和权限

缺省值, 缺省值

改变, 改变字段的缺省值

删除, 删除数据

升级, 版本间迁移

时间线, 备份和恢复

事务, 事务

视图, 视图

受修饰的名字, 创建模式

数据库

privilege to create, 角色属性

数组

检索, 在数组中检索

输入和输出, 数组的输入和输出语法

修改, 修改数组

搜索路径, 模式搜索路径

所有者, 权限

外键, 外键, 外键

唯一约束, 唯一约束

未修饰的名字, 模式搜索路径

系统表

模式, 系统表模式

限制

用 DROP, 依赖性跟踪

行, 表的基本概念

用户, 数据库角色

用户名映射, 用户名映射

用户认证, 用户认证

约束, 约束

非空, 非空约束

检查, 检查约束

命名, 检查约束

排除, 排除约束

删除, 删除约束

外键, 外键

外键作用, 外键

唯一, 唯一约束

增加, 增加约束

主键, 主键

约束排除, 分区和约束排除

在线备份, 备份和恢复

主键, 主键

字段

删除, 删除字段

系统字段, 系统字段

增加, 增加字段

重命名, 重命名字段

字段数据类型

修改, 修改字段的数据类型

A

ABORT, ABORT

abs, Mathematical Functions and Operators

acos, Mathematical Functions and Operators

adminpack, adminpack

age, Date/Time Functions and Operators

aggregate function, Aggregate Functions

built-in, Aggregate Functions

invocation, Aggregate Expressions

user-defined, User-Defined Aggregates

AIX

installation on, AIX

IPC configuration, Shared Memory and Semaphores

alias

for table name in query, Joins Between Tables

in the FROM clause, Table and Column Aliases

in the select list, Column Labels

ALL, Subquery Expressions, Row and Array Comparisons

allow_system_table_mods configuration parameter, Developer Options

ALTER AGGREGATE, ALTER AGGREGATE

ALTER CONVERSION, ALTER CONVERSION

ALTER DATABASE, ALTER DATABASE

ALTER DEFAULT PRIVILEGES, ALTER DEFAULT PRIVILEGES

ALTER DOMAIN, ALTER DOMAIN

ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPER

ALTER FUNCTION, ALTER FUNCTION

ALTER GROUP, ALTER GROUP

ALTER INDEX, ALTER INDEX

ALTER LANGUAGE, ALTER LANGUAGE

ALTER LARGE OBJECT, ALTER LARGE OBJECT

ALTER OPERATOR, ALTER OPERATOR

ALTER OPERATOR CLASS, ALTER OPERATOR CLASS

ALTER OPERATOR FAMILY, ALTER OPERATOR FAMILY

ALTER ROLE, ALTER ROLE

ALTER SCHEMA, ALTER SCHEMA

ALTER SEQUENCE, ALTER SEQUENCE

ALTER SERVER, ALTER SERVER

ALTER TABLE, ALTER TABLE

ALTER TABLESPACE, ALTER TABLESPACE

ALTER TEXT SEARCH CONFIGURATION, ALTER TEXT SEARCH CONFIGURATION

ALTER TEXT SEARCH DICTIONARY, ALTER TEXT SEARCH DICTIONARY

ALTER TEXT SEARCH PARSER, ALTER TEXT SEARCH PARSER

ALTER TEXT SEARCH TEMPLATE, ALTER TEXT SEARCH TEMPLATE

ALTER TRIGGER, ALTER TRIGGER

ALTER TYPE, ALTER TYPE

ALTER USER, ALTER USER

ALTER USER MAPPING, ALTER USER MAPPING

ALTER VIEW, ALTER VIEW

ANALYZE, Updating Planner Statistics, ANALYZE

AND (operator), Logical Operators

anonymous code blocks, DO

any, Pseudo-Types, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

anyarray, Pseudo-Types

anyelement, Pseudo-Types

anyenum, Pseudo-Types

anynonarray, Pseudo-Types

applicable role, applicable_roles

application_name configuration parameter, What To Log

arbitrary precision numbers, Arbitrary Precision Numbers

archive_cleanup_command recovery parameter, Archive recovery settings

archive_command configuration parameter, Archiving

archive_mode configuration parameter, Archiving

archive_timeout configuration parameter, Archiving

area, Geometric Functions and Operators

ARRAY, Array Constructors, 数组

accessing, 访问数组

constant, 数组值输入

constructor, Array Constructors

declaration, 数组类型的声明

determination of result type, UNION, CASE, and Related Constructs

of user-defined type, User-Defined Types

array_agg, Aggregate Functions

array_append, Array Functions and Operators

array_cat, Array Functions and Operators

array_dims, Array Functions and Operators

array_fill, Array Functions and Operators

array_length, Array Functions and Operators

array_lower, Array Functions and Operators

array_ndims, Array Functions and Operators

array_nulls configuration parameter, Previous PostgreSQL Versions

array_prepend, Array Functions and Operators

array_to_string, Array Functions and Operators

array_upper, Array Functions and Operators

ascii, String Functions and Operators

asin, Mathematical Functions and Operators

asynchronous commit, Asynchronous Commit

AT TIME ZONE, AT TIME ZONE

atan, Mathematical Functions and Operators

atan2, Mathematical Functions and Operators

authentication_timeout configuration parameter, Security and Authentication

auto-increment

see serial

autocommit

bulk-loading data, Disable Autocommit

psql, Variables

autovacuum

configuration parameters, Automatic Vacuuming

general information, The Autovacuum Daemon

autovacuum configuration parameter, Automatic Vacuuming

autovacuum_analyze_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_analyze_threshold configuration parameter, Automatic Vacuuming

autovacuum_freeze_max_age configuration parameter, Automatic Vacuuming

autovacuum_max_workers configuration parameter, Automatic Vacuuming

autovacuum_naptime configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_delay configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_limit configuration parameter, Automatic Vacuuming

autovacuum_vacuum_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_vacuum_threshold configuration parameter, Automatic Vacuuming

auto_explain, auto_explain

auto_explain.log_analyze configuration parameter, Configuration parameters

auto_explain.log_buffers configuration parameter, Configuration parameters

auto_explain.log_format configuration parameter, Configuration parameters

auto_explain.log_min_duration configuration parameter, Configuration parameters

auto_explain.log_nested_statements configuration parameter, Configuration parameters

auto_explain.log_verbose configuration parameter, Configuration parameters

average, Aggregate Functions, Aggregate Functions

B

B-tree

see index

backslash escapes, String Constants with C-Style Escapes

backslash_quote configuration parameter, Previous PostgreSQL Versions

backup, System Administration Functions

base type, The PostgreSQL Type System

BEGIN, BEGIN

BETWEEN, Comparison Operators

BETWEEN SYMMETRIC, Comparison Operators

bgwriter_delay configuration parameter, Background Writer

bgwriter_lru_maxpages configuration parameter, Background Writer

bgwriter_lru_multiplier configuration parameter, Background Writer

bigint, Numeric Constants, Integer Types

bigserial, Serial Types

binary data, Binary Data Types

functions, Binary String Functions and Operators

binary string

concatenation, Binary String Functions and Operators

length, Binary String Functions and Operators

bison, 要求

bit string

constant, Bit-String Constants

data type, Bit String Types

bit strings

functions, Bit String Functions and Operators

bitmap scan, Planner Method Configuration

bitmap scan位图扫描, 组合多个索引

bit_and, Aggregate Functions

bit_length, String Functions and Operators

bit_or, Aggregate Functions

BLOB

see large object

block_size configuration parameter, Preset Options

bonjour configuration parameter, Connection Settings

bonjour_name configuration parameter, Connection Settings

Boolean

data type, Boolean Type

operators

see operators, logical

bool_and, Aggregate Functions

bool_or, Aggregate Functions

booting

starting the server during, Starting the Database Server

box (data type), Boxes

BSD/OS

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

btree_gin, btree_gin

btree_gist, btree_gist

btrim, String Functions and Operators

bytea, Binary Data Types

bytea_output configuration parameter, Statement Behavior

C

C, libpq - C Library, ECPG - Embedded SQL in C

C++, Using C++ for Extensibility

canceling

SQL command, Cancelling Queries in Progress

CASE, Conditional Expressions

determination of result type, UNION, CASE, and Related Constructs

case sensitivity

of SQL commands, Identifiers and Key Words

cast

I/O conversion, CREATE CAST

cbrt, Mathematical Functions and Operators

ceiling, Mathematical Functions and Operators

center, Geometric Functions and Operators

Certificate, 证书认证

char, Character Types

character, Character Types

character set, Locale and Formatting, Preset Options, 字符集支持

character string

concatenation, String Functions and Operators

constant, String Constants

data types, Character Types

length, String Functions and Operators

character varying, Character Types

char_length, String Functions and Operators

checkpoint, WAL Configuration, CHECKPOINT

checkpoint_completion_target configuration parameter, Checkpoints

checkpoint_segments configuration parameter, Checkpoints

checkpoint_timeout configuration parameter, Checkpoints

checkpoint_warning configuration parameter, Checkpoints

check_function_bodies configuration parameter, Statement Behavior

chkpass, chkpass

chr, String Functions and Operators

cid, Object Identifier Types

cidr, cidr

circle, Circles

citext, citext

client authentication

timeout during, Security and Authentication

client_encoding configuration parameter, Locale and Formatting

client_min_messages configuration parameter, When To Log

clock_timestamp, Date/Time Functions and Operators

CLOSE, CLOSE

CLUSTER, CLUSTER

of databases

see database cluster

clusterdb, clusterdb

clustering, High Availability, Load Balancing, and Replication

cmax, 系统字段

cmin, 系统字段

COALESCE, COALESCE

column, Concepts

column reference, Column References

col_description, System Information Functions

COMMENT, COMMENT

about database objects, System Information Functions

in SQL, Comments

COMMIT, COMMIT

COMMIT PREPARED, COMMIT PREPARED

commit_delay configuration parameter, Settings

commit_siblings configuration parameter, Settings

common table expression

see WITH

comparison

operators, Comparison Operators

row-wise, Row and Array Comparisons

subquery result row, Subquery Expressions

compiling

libpq applications, Building libpq Programs

composite type, Composite Types, The PostgreSQL Type System

constant, Composite Value Input

constructor, Row Constructors

computed field, SQL Functions on Composite Types

concurrency, Concurrency Control

conditional expression, Conditional Expressions

configuration

of recovery

of a standby server, Recovery Configuration

of the server, Server Configuration

of the server

functions, System Administration Functions

configure, 安装过程

config_file configuration parameter, File Locations

conjunction, Logical Operators

connection service file, The Connection Service File

constant, Constants

constraint exclusion, Other Planner Options

constraint_exclusion configuration parameter, Other Planner Options

CONTINUE

in PL/pgSQL, CONTINUE

convert, String Functions and Operators

convert_from, String Functions and Operators

convert_to, String Functions and Operators

COPY, Populating a Table With Rows, COPY

with libpq, Functions Associated with the COPY Command

correlation, Aggregate Functions

cos, Mathematical Functions and Operators

cot, Mathematical Functions and Operators

count, Aggregate Functions

covariance

population, Aggregate Functions

sample, Aggregate Functions

cpu_index_tuple_cost configuration parameter, Planner Cost Constants

cpu_operator_cost configuration parameter, Planner Cost Constants

cpu_tuple_cost configuration parameter, Planner Cost Constants

CREATE DATABASE, 创建一个数据库

CREATE AGGREGATE, CREATE AGGREGATE

CREATE CAST, CREATE CAST

CREATE CONSTRAINT TRIGGER, CREATE CONSTRAINT TRIGGER

CREATE CONVERSION, CREATE CONVERSION

CREATE DATABASE, CREATE DATABASE

CREATE DOMAIN, CREATE DOMAIN

CREATE FOREIGN DATA WRAPPER, CREATE FOREIGN DATA WRAPPER

CREATE FUNCTION, CREATE FUNCTION

CREATE GROUP, CREATE GROUP

CREATE INDEX, CREATE INDEX

CREATE LANGUAGE, CREATE LANGUAGE

CREATE OPERATOR, CREATE OPERATOR

CREATE OPERATOR CLASS, CREATE OPERATOR CLASS

CREATE OPERATOR FAMILY, CREATE OPERATOR FAMILY

CREATE ROLE, 数据库角色, CREATE ROLE

CREATE RULE, CREATE RULE

CREATE SCHEMA, CREATE SCHEMA

CREATE SEQUENCE, CREATE SEQUENCE

CREATE SERVER, CREATE SERVER

CREATE TABLE, Creating a New Table, CREATE TABLE

CREATE TABLE AS, CREATE TABLE AS

CREATE TABLESPACE, 表空间, CREATE TABLESPACE

CREATE TEXT SEARCH CONFIGURATION, CREATE TEXT SEARCH CONFIGURATION

CREATE TEXT SEARCH DICTIONARY, CREATE TEXT SEARCH DICTIONARY

CREATE TEXT SEARCH PARSER, CREATE TEXT SEARCH PARSER

CREATE TEXT SEARCH TEMPLATE, CREATE TEXT SEARCH TEMPLATE

CREATE TRIGGER, CREATE TRIGGER

CREATE TYPE, CREATE TYPE

CREATE USER, CREATE USER

CREATE USER MAPPING, CREATE USER MAPPING

CREATE VIEW, CREATE VIEW

createdb, Creating a Database, 创建一个数据库, createdb

createlang, createlang

createuser, 数据库角色, createuser

cross compilation, 安装过程

cross join, Joined Tables

cstring, Pseudo-Types

ctid, 系统字段, View Rules in Non-SELECT Statements

cube, cube

cume_dist, Window Functions

current_catalog, System Information Functions

current_database, System Information Functions

current_date, Date/Time Functions and Operators

current_schema, System Information Functions

current_time, Date/Time Functions and Operators

current_timestamp, Date/Time Functions and Operators

current_user, System Information Functions

currval, Sequence Manipulation Functions

cursor

CLOSE, CLOSE

DECLARE, DECLARE

FETCH, FETCH

in PL/pgSQL, 游标

MOVE, MOVE

showing the query plan, EXPLAIN

cursor_tuple_fraction configuration parameter, Other Planner Options

custom_variable_classes configuration parameter, Customized Options

Cygwin

installation on, Cygwin

D

data area

see database cluster

data partitioning, High Availability, Load Balancing, and Replication

data type, Data Types

base, The PostgreSQL Type System

category, Overview

composite, The PostgreSQL Type System

constant, Constants of Other Types

conversion, Type Conversion

enumerated (enum), Enumerated Types

internal organization, Base Types in C-Language Functions

numeric, Numeric Types

type cast, Type Casts

user-defined, User-Defined Types

database, 管理数据库

creating, Creating a Database

database activity

monitoring, Monitoring Database Activity

database cluster, Concepts, Creating a Database Cluster

data_directory configuration parameter, File Locations

date, Date/Time Types, Dates

constants, Special Values

current, Current Date/Time

output format, Date/Time Output

see also formatting

DateStyle configuration parameter, Locale and Formatting

date_part, Date/Time Functions and Operators, EXTRACT, date_part

date_trunc, Date/Time Functions and Operators, date_trunc

dblink, dblink

db_user_namespace configuration parameter, Security and Authentication

deadlock, Deadlocks

timeout during, Lock Management

deadlock_timeout configuration parameter, Lock Management

DEALLOCATE, DEALLOCATE

debug_assertions configuration parameter, Developer Options

debug_deadlocks configuration parameter, Developer Options

debug_pretty_print configuration parameter, What To Log

debug_print_parse configuration parameter, What To Log

debug_print_plan configuration parameter, What To Log

debug_print_rewritten configuration parameter, What To Log

decimal

see numeric

DECLARE, DECLARE

decode, String Functions and Operators

decode_bytea

in PL/Perl, Utility functions in PL/Perl

default_statistics_target configuration parameter, Other Planner Options

default_tablespace configuration parameter, Statement Behavior

default_text_search_config configuration parameter, Locale and Formatting

default_transaction_isolation configuration parameter, Statement Behavior

default_transaction_read_only configuration parameter, Statement Behavior

default_with_oids configuration parameter, Previous PostgreSQL Versions

degrees, Mathematical Functions and Operators

delay, Delaying Execution

DELETE, Deletions, DELETE

dense_rank, Window Functions

diameter, Geometric Functions and Operators

dict_int, dict_int

dict_xsyn, dict_xsyn

Digital UNIX

see Tru64 UNIX

dirty read, Transaction Isolation

DISCARD, DISCARD

disjunction, Logical Operators

disk drive, WAL Internals

disk space, Recovering Disk Space

disk usage, Determining Disk Usage

DISTINCT, Querying a Table, DISTINCT

div, Mathematical Functions and Operators

DO, DO

document

text search, What Is a Document?

dollar quoting, Dollar-Quoted String Constants

double precision, Floating-Point Types

DROP AGGREGATE, DROP AGGREGATE

DROP CAST, DROP CAST

DROP CONVERSION, DROP CONVERSION

DROP DATABASE, 删除数据库, DROP DATABASE

DROP DOMAIN, DROP DOMAIN

DROP FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER

DROP FUNCTION, DROP FUNCTION

DROP GROUP, DROP GROUP

DROP INDEX, DROP INDEX

DROP LANGUAGE, DROP LANGUAGE

DROP OPERATOR, DROP OPERATOR

DROP OPERATOR CLASS, DROP OPERATOR CLASS

DROP OPERATOR FAMILY, DROP OPERATOR FAMILY

DROP OWNED, DROP OWNED

DROP ROLE, 数据库角色, DROP ROLE

DROP RULE, DROP RULE

DROP SCHEMA, DROP SCHEMA

DROP SEQUENCE, DROP SEQUENCE

DROP SERVER, DROP SERVER

DROP TABLE, Creating a New Table, DROP TABLE

DROP TABLESPACE, DROP TABLESPACE

DROP TEXT SEARCH CONFIGURATION, DROP TEXT SEARCH CONFIGURATION

DROP TEXT SEARCH DICTIONARY, DROP TEXT SEARCH DICTIONARY

DROP TEXT SEARCH PARSER, DROP TEXT SEARCH PARSER

DROP TEXT SEARCH TEMPLATE, DROP TEXT SEARCH TEMPLATE

DROP TRIGGER, DROP TRIGGER

DROP TYPE, DROP TYPE

DROP USER, DROP USER

DROP USER MAPPING, DROP USER MAPPING

DROP VIEW, DROP VIEW

dropdb, 删除数据库, dropdb

droplang, droplang

dropuser, 数据库角色, dropuser

DTD, Creating XML Values

DTrace, 安装过程, Dynamic Tracing

duplicate, Querying a Table

duplicates, DISTINCT

dynamic loading, Other Defaults, Dynamic Loading

dynamic_library_path, Dynamic Loading

dynamic_library_path configuration parameter, Other Defaults

E

earthdistance, earthdistance

ECPG, ECPG - Embedded SQL in C, ecpg

effective_cache_size configuration parameter, Planner Cost Constants

effective_io_concurrency configuration parameter, Asynchronous Behavior

elog, Reporting Errors Within the Server

in PL/Perl, Utility functions in PL/Perl

in PL/Python, Utility Functions

in PL/Tcl, Database Access from PL/Tcl

embedded SQL

in C, ECPG - Embedded SQL in C

enabled role, enabled_roles

enable_bitmapscan configuration parameter, Planner Method Configuration

enable_hashagg configuration parameter, Planner Method Configuration

enable_hashjoin configuration parameter, Planner Method Configuration

enable_indexscan configuration parameter, Planner Method Configuration

enable_material configuration parameter, Planner Method Configuration

enable_mergejoin configuration parameter, Planner Method Configuration

enable_nestloop configuration parameter, Planner Method Configuration

enable_seqscan configuration parameter, Planner Method Configuration

enable_sort configuration parameter, Planner Method Configuration

enable_tidscan configuration parameter, Planner Method Configuration

encode, String Functions and Operators

encode_array_constructor

in PL/Perl, Utility functions in PL/Perl

encode_array_literal

in PL/Perl, Utility functions in PL/Perl

encode_bytea

in PL/Perl, Utility functions in PL/Perl

encryption, Encryption Options

for specific columns, pgcrypto

END, END

enumerated types, Enumerated Types

environment variable, Environment Variables

ereport, Reporting Errors Within the Server

error codes

libpq, Main Functions

list of, PostgreSQL Error Codes

error message, Connection Status Functions

escape string syntax, String Constants with C-Style Escapes

escape_string_warning configuration parameter, Previous PostgreSQL Versions

escaping strings

in libpq, Escaping Strings for Inclusion in SQL Commands

every, Aggregate Functions

EXCEPT, Combining Queries

exceptions

in PL/PgSQL, Trapping Errors捕获错误

EXECUTE, EXECUTE

EXISTS, Subquery Expressions

EXIT

in PL/pgSQL, 退出

exp, Mathematical Functions and Operators

EXPLAIN, Using EXPLAIN, EXPLAIN

expression

order of evaluation, Expression Evaluation Rules

syntax, Value Expressions

extending SQL, Extending SQL

external_pid_file configuration parameter, File Locations

extract, Date/Time Functions and Operators, EXTRACT, date_part

extra_float_digits configuration parameter, Locale and Formatting

F

failover, High Availability, Load Balancing, and Replication

false, Boolean Type

fast path, The Fast-Path Interface

FETCH, FETCH

field

computed, SQL Functions on Composite Types

field selection, Field Selection

first_value, Window Functions

flex, 要求

float4

see real

float8

see double precision

floating point, Floating-Point Types

floating-point

display, Locale and Formatting

floor, Mathematical Functions and Operators

formatting, Data Type Formatting Functions

format_type, System Information Functions

Free Space Map, Free Space Map

FreeBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

from_collapse_limit configuration parameter, Other Planner Options

FSM

see Free Space Map

fsync configuration parameter, Settings

full text search, Full Text Search

data types, Text Search Types

functions and operators, Text Search Types

full_page_writes configuration parameter, Settings

function, Functions and Operators

default values for arguments, SQL Functions with Default Values for Arguments

in the FROM clause, Table Functions

internal, Internal Functions

invocation, Function Calls

mixed notation, Using mixed notation

named notation, Using named notation

named parameter, SQL Functions with Parameter Names

output parameter, SQL Functions with Output Parameters

polymorphic, Polymorphic Types

positional notation, Using positional notation

RETURNS TABLE, SQL Functions Returning TABLE

type resolution in an invocation, Functions

user-defined, User-Defined Functions

in C, C-Language Functions
in SQL, Query Language (SQL) Functions

variadic, SQL Functions with Variable Numbers of Arguments

with SETOF, SQL Functions Returning Sets

fuzzystrmatch, fuzzystrmatch

G

generate_series, Set Returning Functions

generate_subscripts, Set Returning Functions

genetic query optimization, Genetic Query Optimizer

GEQO

see genetic query optimization

geqo configuration parameter, Genetic Query Optimizer

geqo_effort configuration parameter, Genetic Query Optimizer

geqo_generations configuration parameter, Genetic Query Optimizer

geqo_pool_size configuration parameter, Genetic Query Optimizer

geqo_seed configuration parameter, Genetic Query Optimizer

geqo_selection_bias configuration parameter, Genetic Query Optimizer

geqo_threshold configuration parameter, Genetic Query Optimizer

get_bit, Binary String Functions and Operators

get_byte, Binary String Functions and Operators

GIN

see index

gin_fuzzy_search_limit configuration parameter, Other Defaults

GiST

see index

global data

in PL/Python, Sharing Data

in PL/Tcl, Global Data in PL/Tcl

GRANT, 权限, GRANT

GREATEST, GREATEST and LEAST

determination of result type, UNION, CASE, and Related Constructs

GROUP BY, Aggregate Functions, The GROUP BY and HAVING Clauses

grouping, The GROUP BY and HAVING Clauses

GSSAPI, GSSAPI认证

GUID, UUID Type

H

hash

see index

has_any_column_privilege, System Information Functions

has_column_privilege, System Information Functions

has_database_privilege, System Information Functions

has_foreign_data_wrapper_privilege, System Information Functions

has_function_privilege, System Information Functions

has_language_privilege, System Information Functions

has_schema_privilege, System Information Functions

has_sequence_privilege, System Information Functions

has_server_privilege, System Information Functions

has_tablespace_privilege, System Information Functions

has_table_privilege, System Information Functions

HAVING, Aggregate Functions, The GROUP BY and HAVING Clauses

hba_file configuration parameter, File Locations

height, Geometric Functions and Operators

hierarchical database, Concepts

high availability, High Availability, Load Balancing, and Replication

history

of PostgreSQL, A Brief History of PostgreSQL

host name, Database Connection Control Functions

Hot Standby, High Availability, Load Balancing, and Replication

hot_standby configuration parameter, Standby Servers

HP-UX

installation on, HP-UX

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

hstore, hstore

I

ident, 给予Ident的认证

identifier

length, Identifiers and Key Words

syntax of, Identifiers and Key Words

ident_file configuration parameter, File Locations

IFNULL, COALESCE

ignore_system_indexes configuration parameter, Developer Options

IMMUTABLE, Function Volatility Categories

IN, Subquery Expressions, Row and Array Comparisons

include

in configuration file, Setting Parameters

index, 索引

B-tree, 索引类型

building concurrently, Building Indexes Concurrently

examining usage, 检查索引的使用

on expressions, 表达式上的索引

for user-defined data type, Interfacing Extensions To Indexes

GIN, 索引类型, GIN Indexes

text search, GiST and GIN Index Types

GiST, 索引类型, GiST Indexes

text search, GiST and GIN Index Types

hash, 索引类型

locks, Locking and Indexes

partial, 部分索引

index scan, Planner Method Configuration

index索引

and ORDER BY, 索引和ORDER BY

combining multiple indexes组合多个索引, 组合多个索引

multicolumn多字段, 多字段索引

unique唯一, 唯一索引

inet (data type), inet

inet_client_addr, System Information Functions

inet_client_port, System Information Functions

inet_server_addr, System Information Functions

inet_server_port, System Information Functions

information schema, The Information Schema

Inheritance, 继承, Previous PostgreSQL Versions

initcap, String Functions and Operators

initdb, Creating a Database Cluster, initdb

input function, User-Defined Types

of a data type, User-Defined Types

INSERT, Populating a Table With Rows, INSERT

installation

on Windows, Installation from Source Code on Windows

installation安装, 安装指导

int2

see smallint

int4

see integer

int8

see bigint

intagg, intagg

intarray, intarray

integer, Numeric Constants, Integer Types

integer_datetimes configuration parameter, Preset Options

internal, Pseudo-Types

INTERSECT, Combining Queries

interval, Date/Time Types, Interval Input

output format, Interval Output

see also formatting

IntervalStyle configuration parameter, Locale and Formatting

IRIX

installation on, IRIX

shared library, Compiling and Linking Dynamically-Loaded Functions

IS DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS DOCUMENT, XML Predicates

IS FALSE, Comparison Operators

IS NOT DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS NOT FALSE, Comparison Operators

IS NOT NULL, Comparison Operators

IS NOT TRUE, Comparison Operators

IS NOT UNKNOWN, Comparison Operators

IS NULL, Comparison Operators, Platform and Client Compatibility

IS TRUE, Comparison Operators

IS UNKNOWN, Comparison Operators

isclosed, Geometric Functions and Operators

isfinite, Date/Time Functions and Operators

isn, isn

ISNULL, Comparison Operators

isopen, Geometric Functions and Operators

J

join, Joins Between Tables, Joined Tables

controlling the order, Controlling the Planner with Explicit JOIN Clauses

cross, Joined Tables

left, Joined Tables

natural, Joined Tables

outer, Joins Between Tables, Joined Tables

right, Joined Tables

self, Joins Between Tables

join_collapse_limit configuration parameter, Other Planner Options

justify_days, Date/Time Functions and Operators

justify_hours, Date/Time Functions and Operators

justify_interval, Date/Time Functions and Operators

K

Kerberos, Kerberos认证

key word

list of, SQL关键字

syntax of, Identifiers and Key Words

krb_caseins_users configuration parameter, Security and Authentication

krb_server_keyfile configuration parameter, Security and Authentication

krb_srvname configuration parameter, Security and Authentication

L

label

see alias

lag, Window Functions

language_handler, Pseudo-Types

large object, 大对象

lastval, Sequence Manipulation Functions

last_value, Window Functions

lc_collate configuration parameter, Preset Options

lc_ctype configuration parameter, Preset Options

lc_messages configuration parameter, Locale and Formatting

lc_monetary configuration parameter, Locale and Formatting

lc_numeric configuration parameter, Locale and Formatting

lc_time configuration parameter, Locale and Formatting

LDAP, 安装过程, LDAP认证

LDAP connection parameter lookup, LDAP Lookup of Connection Parameters

ldconfig, 共享库

lead, Window Functions

LEAST, GREATEST and LEAST

determination of result type, UNION, CASE, and Related Constructs

left join, Joined Tables

length, Geometric Functions and Operators

of a binary string

see binary strings, length

of a character string

see character string, length

length(tsvector), Manipulating Documents

lex, 要求

libedit, 要求

libperl, 要求

libpq, libpq - C Library

libpq-fe.h, libpq - C Library, Connection Status Functions

libpq-int.h, Connection Status Functions

libpython, 要求

library finalization function, Dynamic Loading

library initialization function, Dynamic Loading

LIKE, LIKE

and locales, 行为

LIMIT, LIMIT and OFFSET

line segment, Line Segments

linear regression, Aggregate Functions

Linux

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

LISTEN, LISTEN

listen_addresses configuration parameter, Connection Settings

ln, Mathematical Functions and Operators

lo, lo

LOAD, LOAD

load balancing, High Availability, Load Balancing, and Replication

locale, Creating a Database Cluster

localtime, Date/Time Functions and Operators

localtimestamp, Date/Time Functions and Operators

local_preload_libraries configuration parameter, Other Defaults

lock, Explicit Locking, Table-Level Locks, LOCK

advisory, Advisory Locks

monitoring, Viewing Locks

log, Mathematical Functions and Operators

log shipping, High Availability, Load Balancing, and Replication

logging_collector configuration parameter, Where To Log

login privilegeLOGIN 属性, 角色属性

log_autovacuum_min_duration configuration parameter, Automatic Vacuuming

log_btree_build_stats configuration parameter, Developer Options

log_checkpoints configuration parameter, What To Log

log_connections configuration parameter, What To Log

log_destination configuration parameter, Where To Log

log_directory configuration parameter, Where To Log

log_disconnections configuration parameter, What To Log

log_duration configuration parameter, What To Log

log_error_verbosity configuration parameter, What To Log

log_executor_stats configuration parameter, Statistics Monitoring

log_filename configuration parameter, Where To Log

log_hostname configuration parameter, What To Log

log_line_prefix configuration parameter, What To Log

log_lock_waits configuration parameter, What To Log

log_min_duration_statement configuration parameter, When To Log

log_min_error_statement configuration parameter, When To Log

log_min_messages configuration parameter, When To Log

log_parser_stats configuration parameter, Statistics Monitoring

log_planner_stats configuration parameter, Statistics Monitoring

log_rotation_age configuration parameter, Where To Log

log_rotation_size configuration parameter, Where To Log

log_statement configuration parameter, What To Log

log_statement_stats configuration parameter, Statistics Monitoring

log_temp_files configuration parameter, What To Log

log_timezone configuration parameter, What To Log

log_truncate_on_rotation configuration parameter, Where To Log

looks_like_number

in PL/Perl, Utility functions in PL/Perl

loop

in PL/pgSQL, 简单循环

lower, String Functions and Operators

and locales, 行为

lo_close, 关闭一个大对象描述符

lo_compat_privileges configuration parameter, Previous PostgreSQL Versions

lo_creat, 创建大对象, 服务器端函数

lo_create, 创建大对象, 服务器端函数

lo_export, 输出大对象, 服务器端函数

lo_import, 输入大对象, 服务器端函数

lo_import_with_oid, 输入大对象

lo_lseek, 大对象中数据的查找

lo_open, 打开一个现有的大对象, 关闭一个大对象描述符

lo_read, 从大对象中读取数据

lo_tell, 获取一个大对象的当前索引位置

lo_truncate, 截断一个大对象

lo_unlink, 删除一个大对象, 服务器端函数

lo_write, 向大对象中写数据

lpad, String Functions and Operators

lseg, Line Segments

ltree, ltree

ltrim, String Functions and Operators

M

MAC address

see macaddr

macaddr (data type), macaddr

MacOS X

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

magic block, Dynamic Loading

maintenance, Routine Database Maintenance Tasks

maintenance_work_mem configuration parameter, Memory

make, 要求

MANPATH, 环境变量

max, Aggregate Functions

max_connections configuration parameter, Connection Settings

max_files_per_process configuration parameter, Kernel Resource Usage

max_function_args configuration parameter, Preset Options

max_identifier_length configuration parameter, Preset Options

max_index_keys configuration parameter, Preset Options

max_locks_per_transaction configuration parameter, Lock Management

max_prepared_transactions configuration parameter, Memory

max_stack_depth configuration parameter, Memory

max_standby_archive_delay configuration parameter, Standby Servers

max_standby_streaming_delay configuration parameter, Standby Servers

max_wal_senders configuration parameter, Streaming Replication

md5, String Functions and Operators, 口令认证

memory context

in SPI, Memory Management

min, Aggregate Functions

MinGW

installation on, MinGW/Native Windows

mod, Mathematical Functions and Operators

monitoring

database activity, Monitoring Database Activity

MOVE, MOVE

MVCC, Introduction

N

name

syntax of, Identifiers and Key Words

NaN

see not a number

natural join, Joined Tables

negation, Logical Operators

NetBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

network

data types, Network Address Types

Network Attached Storage (NAS)

see Network File Systems

Network File Systems, Network File Systems

nextval, Sequence Manipulation Functions

NFS

see Network File Systems

non-durable, Non-Durable Settings

nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing

nonrepeatable read, Transaction Isolation

NOT (operator), Logical Operators

not a number

double precision, Floating-Point Types

numeric (data type), Arbitrary Precision Numbers

NOT IN, Subquery Expressions, Row and Array Comparisons

notation

functions, Calling Functions

notice processor, Notice Processing

notice receiver, Notice Processing

notice processing

in libpq, Notice Processing

NOTIFY, NOTIFY

in libpq, Asynchronous Notification

NOTNULL, Comparison Operators

now, Date/Time Functions and Operators

npoints, Geometric Functions and Operators

nth_value, Window Functions

ntile, Window Functions

null value

comparing, Comparison Operators

default value, 缺省值

in DISTINCT, DISTINCT

in libpq, Retrieving Query Result Information

in PL/Perl, PL/Perl Functions and Arguments

PL/Python, Null, None

NULLIF, NULLIF

number

constant, Numeric Constants

numeric, Numeric Constants

numeric (data type), Arbitrary Precision Numbers

numnode, Manipulating Queries

NVL, COALESCE

O

object identifier

data type, Object Identifier Types

object-oriented database, Concepts

obj_description, System Information Functions

octet_length, String Functions and Operators

OFFSET, LIMIT and OFFSET

oid, Object Identifier Types

column字段, 系统字段

in libpq, Retrieving Other Result Information

oid2name, oid2name

ONLY, The FROM Clause

opaque, Pseudo-Types

OpenBSD

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

OpenSSL, 安装过程

see also SSL

operator, Functions and Operators

invocation, Operator Invocations

logical, Logical Operators

precedence, Lexical Precedence

syntax, Operators

type resolution in an invocation, Operators

user-defined, User-Defined Operators

operator class, Operator Classes and Operator Families, Index Methods and Operator Classes

operator family, Operator Classes and Operator Families, Operator Classes and Operator Families

OR (operator), Logical Operators

Oracle

porting from PL/SQL to PL/pgSQL, 从OraclePL/SQL 进行移植

ORDER BY, Querying a Table, Sorting Rows

ordering operator, System Dependencies on Operator Classes

outer join, Joined Tables

output function

of a data type, User-Defined Types

output function, User-Defined Types

OVER clause, Window Function Calls

overlay, String Functions and Operators

overloading

functions, Function Overloading

operators, User-Defined Operators

P

pageinspect, pageinspect

palloc, Writing Code

PAM, 安装过程, PAM认证

parameter

syntax, Positional Parameters

parenthesis, Value Expressions

password

authentication, 口令认证

of the superuser, Creating a Database Cluster

password file, The Password File

passwordcheck, passwordcheck

password_encryption configuration parameter, Security and Authentication

PATH, 环境变量

for schemas, Statement Behavior

path (data type), Paths

pattern matching, Pattern Matching

patterns

in psql and pg_dump, Patterns

pclose, Geometric Functions and Operators

percent_rank, Window Functions

performance, Performance Tips

perl, 要求, PL/Perl - Perl Procedural Language

pfree, Writing Code

PGAPPNAME, Environment Variables

pgbench, pgbench

PGcancel, Cancelling Queries in Progress

PGCLIENTENCODING, Environment Variables

PGconn, Database Connection Control Functions

PGCONNECT_TIMEOUT, Environment Variables

pgcrypto, pgcrypto

PGDATA, Creating a Database Cluster

PGDATABASE, Environment Variables

PGDATESTYLE, Environment Variables

PGEventProc, Event Callback Procedure

PGGEQO, Environment Variables

PGGSSLIB, Environment Variables

PGHOST, Environment Variables

PGHOSTADDR, Environment Variables

PGKRBSRVNAME, Environment Variables

PGLOCALEDIR, Environment Variables

PGOPTIONS, Environment Variables

PGPASSFILE, Environment Variables

PGPASSWORD, Environment Variables

PGPORT, Environment Variables

PGREALM, Environment Variables

PGREQUIRESSL, Environment Variables

PGresult, Main Functions

pgrowlocks, pgrowlocks

PGSERVICE, Environment Variables

PGSERVICEFILE, Environment Variables

PGSSLCERT, Environment Variables

PGSSLCRL, Environment Variables

PGSSLKEY, Environment Variables

PGSSLMODE, Environment Variables

PGSSLROOTCERT, Environment Variables

pgstattuple, pgstattuple

PGSYSCONFDIR, Environment Variables

PGTZ, Environment Variables

PGUSER, Environment Variables

pgxs, Extension Building Infrastructure

pg_advisory_lock, System Administration Functions

pg_advisory_lock_shared, System Administration Functions

pg_advisory_unlock, System Administration Functions

pg_advisory_unlock_all, System Administration Functions

pg_advisory_unlock_shared, System Administration Functions

pg_aggregate, pg_aggregate

pg_am, pg_am

pg_amop, pg_amop

pg_amproc, pg_amproc

pg_archivecleanup, pg_archivecleanup

pg_attrdef, pg_attrdef

pg_attribute, pg_attribute

pg_authid, pg_authid

pg_auth_members, pg_auth_members

pg_buffercache, pg_buffercache

pg_cancel_backend, System Administration Functions

pg_cast, pg_cast

pg_class, pg_class

pg_client_encoding, String Functions and Operators

pg_column_size, System Administration Functions

pg_config, pg_config

with libpq, Building libpq Programs

with user-defined C functions, Writing Code

pg_conf_load_time, System Information Functions

pg_constraint, pg_constraint

pg_controldata, pg_controldata

pg_conversion, pg_conversion

pg_conversion_is_visible, System Information Functions

pg_ctl, Creating a Database Cluster, Starting the Database Server, pg_ctl

pg_current_xlog_insert_location, System Administration Functions

pg_current_xlog_location, System Administration Functions

pg_cursors, pg_cursors

pg_database, pg_database

pg_database_size, System Administration Functions

pg_db_role_setting, pg_db_role_setting

pg_default_acl, pg_default_acl

pg_depend, pg_depend

pg_description, pg_description

pg_dump, pg_dump

pg_dumpall, pg_dumpall

use during upgrade, 升级

pg_enum, pg_enum

pg_foreign_data_wrapper, pg_foreign_data_wrapper

pg_foreign_server, pg_foreign_server

pg_freespacemap, pg_freespacemap

pg_function_is_visible, System Information Functions

pg_get_constraintdef, System Information Functions

pg_get_expr, System Information Functions

pg_get_functiondef, System Information Functions

pg_get_function_arguments, System Information Functions

pg_get_function_identity_arguments, System Information Functions

pg_get_function_result, System Information Functions

pg_get_indexdef, System Information Functions

pg_get_keywords, System Information Functions

pg_get_ruledef, System Information Functions

pg_get_serial_sequence, System Information Functions

pg_get_triggerdef, System Information Functions

pg_get_userbyid, System Information Functions

pg_get_viewdef, System Information Functions

pg_group, pg_group

pg_has_role, System Information Functions

pg_hba.conf, pg_hba.conf 文件

pg_ident.conf, 用户名映射

pg_index, pg_index

pg_indexes, pg_indexes

pg_indexes_size, System Administration Functions

pg_inherits, pg_inherits

pg_is_in_recovery, System Administration Functions

pg_is_other_temp_schema, System Information Functions

pg_language, pg_language

pg_largeobject, pg_largeobject

pg_largeobject_metadata, pg_largeobject_metadata

pg_last_xlog_receive_location, System Administration Functions

pg_last_xlog_replay_location, System Administration Functions

pg_listening_channels, System Information Functions

pg_locks, pg_locks

pg_ls_dir, System Administration Functions

pg_my_temp_schema, System Information Functions

pg_namespace, pg_namespace

pg_notify, pg_notify

pg_opclass, pg_opclass

pg_opclass_is_visible, System Information Functions

pg_operator, pg_operator

pg_operator_is_visible, System Information Functions

pg_opfamily, pg_opfamily

pg_pltemplate, pg_pltemplate

pg_postmaster_start_time, System Information Functions

pg_prepared_statements, pg_prepared_statements

pg_prepared_xacts, pg_prepared_xacts

pg_proc, pg_proc

pg_read_file, System Administration Functions

pg_relation_filenode, System Administration Functions

pg_relation_filepath, System Administration Functions

pg_relation_size, System Administration Functions

pg_reload_conf, System Administration Functions

pg_restore, pg_restore

pg_rewrite, pg_rewrite

pg_roles, pg_roles

pg_rotate_logfile, System Administration Functions

pg_rules, pg_rules

pg_service.conf, The Connection Service File

pg_settings, pg_settings

pg_shadow, pg_shadow

pg_shdepend, pg_shdepend

pg_shdescription, pg_shdescription

pg_size_pretty, System Administration Functions

pg_sleep, Delaying Execution

pg_standby, pg_standby

pg_start_backup, System Administration Functions

pg_statistic, Statistics Used by the Planner, pg_statistic

pg_stats, Statistics Used by the Planner, pg_stats

pg_stat_file, System Administration Functions

pg_stat_statements, pg_stat_statements

pg_stop_backup, System Administration Functions

pg_switch_xlog, System Administration Functions

pg_tables, pg_tables

pg_tablespace, pg_tablespace

pg_tablespace_databases, System Information Functions

pg_tablespace_size, System Administration Functions

pg_table_is_visible, System Information Functions

pg_table_size, System Administration Functions

pg_terminate_backend, System Administration Functions

pg_timezone_abbrevs, pg_timezone_abbrevs

pg_timezone_names, pg_timezone_names

pg_total_relation_size, System Administration Functions

pg_trgm, pg_trgm

pg_trigger, pg_trigger

pg_try_advisory_lock, System Administration Functions

pg_try_advisory_lock_shared, System Administration Functions

pg_ts_config, pg_ts_config

pg_ts_config_is_visible, System Information Functions

pg_ts_config_map, pg_ts_config_map

pg_ts_dict, pg_ts_dict

pg_ts_dict_is_visible, System Information Functions

pg_ts_parser, pg_ts_parser

pg_ts_parser_is_visible, System Information Functions

pg_ts_template, pg_ts_template

pg_ts_template_is_visible, System Information Functions

pg_type, pg_type

pg_typeof, System Information Functions

pg_type_is_visible, System Information Functions

pg_upgrade, pg_upgrade

pg_user, pg_user

pg_user_mapping, pg_user_mapping

pg_user_mappings, pg_user_mappings

pg_views, pg_views

pg_xlogfile_name, System Administration Functions

pg_xlogfile_name_offset, System Administration Functions

phantom read, Transaction Isolation

pi, Mathematical Functions and Operators

PIC, Compiling and Linking Dynamically-Loaded Functions

PID

determining PID of server process

in libpq, Connection Status Functions

PITR, 备份和恢复

PITR standby, High Availability, Load Balancing, and Replication

PL/Perl, PL/Perl - Perl Procedural Language

PL/PerlU, Trusted and Untrusted PL/Perl

PL/pgSQL, PL/pgSQL - SQL过程语言

PL/Python, PL/Python - Python Procedural Language

PL/SQL (Oracle)

porting to PL/pgSQL, 从OraclePL/SQL 进行移植

PL/Tcl, PL/Tcl - Tcl Procedural Language

plainto_tsquery, Parsing Queries

plperl.on_init configuration parameter, Configuration

plperl.on_plperlu_init configuration parameter, Configuration

plperl.on_plperl_init configuration parameter, Configuration

plperl.use_strict configuration parameter, Configuration

plpgsql.variable_conflict configuration parameter, Variable Substitution

point, Points

polygon, Polygons

polymorphic function, Polymorphic Types

polymorphic type, Polymorphic Types

popen, Geometric Functions and Operators

port, Database Connection Control Functions

port configuration parameter, Connection Settings

position, String Functions and Operators

POSTGRES, The Berkeley POSTGRES Project, Architectural Fundamentals, Starting the Database Server, postgres

postgres user, The PostgreSQL User Account

Postgres95, Postgres95

postgresql.conf, Setting Parameters

postmaster, postmaster

post_auth_delay configuration parameter, Developer Options

power, Mathematical Functions and Operators

PQbackendPID, Connection Status Functions

PQbinaryTuples, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQcancel, Cancelling Queries in Progress

PQclear, Main Functions

PQclientEncoding, Control Functions

PQcmdStatus, Retrieving Other Result Information

PQcmdTuples, Retrieving Other Result Information

PQconndefaults, Database Connection Control Functions

PQconnectdb, Database Connection Control Functions

PQconnectdbParams, Database Connection Control Functions

PQconnectionNeedsPassword, Connection Status Functions

PQconnectionUsedPassword, Connection Status Functions

PQconnectPoll, Database Connection Control Functions

PQconnectStart, Database Connection Control Functions

PQconnectStartParams, Database Connection Control Functions

PQconninfoFree, Miscellaneous Functions

PQconninfoParse, Database Connection Control Functions

PQconsumeInput, Asynchronous Command Processing

PQcopyResult, Miscellaneous Functions

PQdb, Connection Status Functions

PQdescribePortal, Main Functions

PQdescribePrepared, Main Functions

PQencryptPassword, Miscellaneous Functions

PQendcopy, Obsolete Functions for COPY

PQerrorMessage, Connection Status Functions

PQescapeBytea, Escaping Strings for Inclusion in SQL Commands

PQescapeByteaConn, Escaping Strings for Inclusion in SQL Commands

PQescapeIdentifier, Escaping Strings for Inclusion in SQL Commands

PQescapeLiteral, Escaping Strings for Inclusion in SQL Commands

PQescapeString, Escaping Strings for Inclusion in SQL Commands

PQescapeStringConn, Escaping Strings for Inclusion in SQL Commands

PQexec, Main Functions

PQexecParams, Main Functions

PQexecPrepared, Main Functions

PQfformat, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQfinish, Database Connection Control Functions

PQfireResultCreateEvents, Miscellaneous Functions

PQflush, Asynchronous Command Processing

PQfmod, Retrieving Query Result Information

PQfn, The Fast-Path Interface

PQfname, Retrieving Query Result Information

PQfnumber, Retrieving Query Result Information

PQfreeCancel, Cancelling Queries in Progress

PQfreemem, Miscellaneous Functions

PQfsize, Retrieving Query Result Information

PQftable, Retrieving Query Result Information

PQftablecol, Retrieving Query Result Information

PQftype, Retrieving Query Result Information

PQgetCancel, Cancelling Queries in Progress

PQgetCopyData, Functions for Receiving COPY Data

PQgetisnull, Retrieving Query Result Information

PQgetlength, Retrieving Query Result Information

PQgetline, Obsolete Functions for COPY

PQgetlineAsync, Obsolete Functions for COPY

PQgetResult, Asynchronous Command Processing

PQgetssl, Connection Status Functions

PQgetvalue, Retrieving Query Result Information

PQhost, Connection Status Functions

PQinitOpenSSL, SSL library initialization

PQinitSSL, SSL library initialization

PQinstanceData, Event Support Functions

PQisBusy, Asynchronous Command Processing

PQisnonblocking, Asynchronous Command Processing

PQisthreadsafe, Behavior in Threaded Programs

PQmakeEmptyPGresult, Miscellaneous Functions

PQnfields, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQnotifies, Asynchronous Notification

PQnparams, Retrieving Query Result Information

PQntuples, Retrieving Query Result Information

PQoidStatus, Retrieving Other Result Information

PQoidValue, Retrieving Other Result Information

PQoptions, Connection Status Functions

PQparameterStatus, Connection Status Functions

PQparamtype, Retrieving Query Result Information

PQpass, Connection Status Functions

PQport, Connection Status Functions

PQprepare, Main Functions

PQprint, Retrieving Query Result Information

PQprotocolVersion, Connection Status Functions

PQputCopyData, Functions for Sending COPY Data

PQputCopyEnd, Functions for Sending COPY Data

PQputline, Obsolete Functions for COPY

PQputnbytes, Obsolete Functions for COPY

PQregisterEventProc, Event Support Functions

PQrequestCancel, Cancelling Queries in Progress

PQreset, Database Connection Control Functions

PQresetPoll, Database Connection Control Functions

PQresetStart, Database Connection Control Functions

PQresStatus, Main Functions

PQresultAlloc, Miscellaneous Functions

PQresultErrorField, Main Functions

PQresultErrorMessage, Main Functions

PQresultInstanceData, Event Support Functions

PQresultSetInstanceData, Event Support Functions

PQresultStatus, Main Functions

PQsendDescribePortal, Asynchronous Command Processing

PQsendDescribePrepared, Asynchronous Command Processing

PQsendPrepare, Asynchronous Command Processing

PQsendQuery, Asynchronous Command Processing

PQsendQueryParams, Asynchronous Command Processing

PQsendQueryPrepared, Asynchronous Command Processing

PQserverVersion, Connection Status Functions

PQsetClientEncoding, Control Functions

PQsetdb, Database Connection Control Functions

PQsetdbLogin, Database Connection Control Functions

PQsetErrorVerbosity, Control Functions

PQsetInstanceData, Event Support Functions

PQsetnonblocking, Asynchronous Command Processing

PQsetNoticeProcessor, Notice Processing

PQsetNoticeReceiver, Notice Processing

PQsetResultAttrs, Miscellaneous Functions

PQsetvalue, Miscellaneous Functions

PQsocket, Connection Status Functions

PQstatus, Connection Status Functions

PQtrace, Control Functions

PQtransactionStatus, Connection Status Functions

PQtty, Connection Status Functions

PQunescapeBytea, Escaping Strings for Inclusion in SQL Commands

PQuntrace, Control Functions

PQuser, Connection Status Functions

predicate locking, Serializable Isolation versus True Serializability

PREPARE, PREPARE

PREPARE TRANSACTION, PREPARE TRANSACTION

prepared statements

creating, PREPARE

executing, EXECUTE

removing, DEALLOCATE

showing the query plan, EXPLAIN

preparing a query

in PL/Tcl, Database Access from PL/Tcl

in PL/pgSQL, Plan Caching

in PL/Python, Database Access

pre_auth_delay configuration parameter, Developer Options

primary_conninfo recovery parameter, Standby server settings

privilege

querying, System Information Functions

with rules, Rules and Privileges

with views, Rules and Privileges

procedural language, Procedural Languages

handler for, Writing A Procedural Language Handler

protocol

frontend-backend, Frontend/Backend Protocol

ps

to monitor activity, Standard Unix Tools

psql, Accessing a Database, psql

Python, PL/Python - Python Procedural Language

Q

query, Querying a Table, Queries

query plan, Using EXPLAIN

query tree, The Query Tree

querytree, Manipulating Queries

quotation marks

and identifiers, Identifiers and Key Words

escaping, String Constants

quote_ident, String Functions and Operators

in PL/Perl, Utility functions in PL/Perl

use in PL/PgSQL, 执行动态命令

quote_literal, String Functions and Operators

in PL/Perl, Utility functions in PL/Perl

use in PL/PgSQL, 执行动态命令

quote_nullable, String Functions and Operators

in PL/Perl, Utility functions in PL/Perl

use in PL/PgSQL, 执行动态命令

R

radians, Mathematical Functions and Operators

radius, Geometric Functions and Operators, RADIUS认证

RAISE, 错误和消息

random, Mathematical Functions and Operators

random_page_cost configuration parameter, Planner Cost Constants

range table, The Query Tree

rank, Window Functions

read-only transaction, Statement Behavior

readline, 要求

real, Floating-Point Types

REASSIGN OWNED, REASSIGN OWNED

record, Pseudo-Types

recovery_end_command recovery parameter, Archive recovery settings

recovery_target_inclusive recovery parameter, Recovery target settings

recovery_target_time recovery parameter, Recovery target settings

recovery_target_timeline recovery parameter, Recovery target settings

recovery_target_xid recovery parameter, Recovery target settings

rectangle, Boxes

referential integrity参照完整性, 外键

regclass, Object Identifier Types

regconfig, Object Identifier Types

regdictionary, Object Identifier Types

regexp_matches, POSIX Regular Expressions

regexp_replace, POSIX Regular Expressions

regexp_split_to_array, POSIX Regular Expressions

regexp_split_to_table, POSIX Regular Expressions

regoper, Object Identifier Types

regoperator, Object Identifier Types

regproc, Object Identifier Types

regprocedure, Object Identifier Types

regression intercept, Aggregate Functions

regression slope, Aggregate Functions

regression test, 安装过程

regression tests, Regression Tests

regtype, Object Identifier Types

regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions

see also pattern matching

reindex, Routine Reindexing, REINDEX

reindexdb, reindexdb

relation, Concepts

relational database, Concepts

RELEASE SAVEPOINT, RELEASE SAVEPOINT

repeat, String Functions and Operators

replace, String Functions and Operators

replication, High Availability, Load Balancing, and Replication

reporting errors

in PL/PgSQL, 错误和消息

RESET, RESET

restartpoint, WAL Configuration

restore_command recovery parameter, Archive recovery settings

RETURN NEXT

in PL/PgSQL, RETURN NEXT和RETURN QUERY

RETURN QUERY

in PL/PgSQL, RETURN NEXT和RETURN QUERY

RETURNING INTO

in PL/pgSQL, 执行一个仅有单行结果的查询

REVOKE, 权限, REVOKE

right join, Joined Tables

role

applicable, applicable_roles

enabled, enabled_roles

membership in角色成员, 角色成员

ROLLBACK, ROLLBACK

psql, Variables

ROLLBACK PREPARED, ROLLBACK PREPARED

ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT

round, Mathematical Functions and Operators

routine maintenance, Routine Database Maintenance Tasks

row, Concepts, Row Constructors

row estimation

planner, Row Estimation Examples

row type, Composite Types

constructor, Row Constructors

row-wise comparison, Row and Array Comparisons

row_number, Window Functions

rpad, String Functions and Operators

rtrim, String Functions and Operators

rule, The Rule System

and views, Views and the Rule System

for DELETE, Rules on INSERT, UPDATE, and DELETE

for INSERT, Rules on INSERT, UPDATE, and DELETE

for SELECT, How SELECT Rules Work

compared with triggers, Rules versus Triggers

for UPDATE, Rules on INSERT, UPDATE, and DELETE

S

SAVEPOINT, SAVEPOINT

savepoints

defining, SAVEPOINT

releasing, RELEASE SAVEPOINT

rolling back, ROLLBACK TO SAVEPOINT

scalar

see expression

schema, 概述

current, System Information Functions

SCO

installation on, SCO OpenServer and SCO UnixWare

SCO OpenServer

IPC configuration, Shared Memory and Semaphores

search path

current, System Information Functions

search_path configuration parameter, Statement Behavior

seg, seg

segment_size configuration parameter, Preset Options

SELECT, Querying a Table, Queries, SELECT

select list, Select Lists

SELECT INTO, SELECT INTO

in PL/pgSQL, 执行一个仅有单行结果的查询

semaphores, Shared Memory and Semaphores

sequence, Sequence Manipulation Functions

and serial type, Serial Types

sequential scan, Planner Method Configuration

seq_page_cost configuration parameter, Planner Cost Constants

serial, Serial Types

serial4, Serial Types

serial8, Serial Types

serializability, Serializable Isolation versus True Serializability

server log, Error Reporting and Logging

log file maintenance, Log File Maintenance

server spoofing, Preventing Server Spoofing

server_encoding configuration parameter, Preset Options

server_version configuration parameter, Preset Options

server_version_num configuration parameter, Preset Options

session_replication_role configuration parameter, Statement Behavior

SET, System Administration Functions, SET

SET CONSTRAINTS, SET CONSTRAINTS

set difference, Combining Queries

set intersection, Combining Queries

set operation, Combining Queries

set returning functions

functions, Set Returning Functions

SET ROLE, SET ROLE

SET SESSION AUTHORIZATION, SET SESSION AUTHORIZATION

SET TRANSACTION, SET TRANSACTION

set union, Combining Queries

SET XML OPTION, Statement Behavior

setseed, Mathematical Functions and Operators

setval, Sequence Manipulation Functions

setweight, Manipulating Documents

set_bit, Binary String Functions and Operators

set_byte, Binary String Functions and Operators

shared library, 共享库, Compiling and Linking Dynamically-Loaded Functions

shared memory, Shared Memory and Semaphores

shared_buffers configuration parameter, Memory

shared_preload_libraries, Shared Memory and LWLocks

shared_preload_libraries configuration parameter, Kernel Resource Usage

SHMMAX, Shared Memory and Semaphores

shobj_description, System Information Functions

SHOW, System Administration Functions, SHOW

shutdown, Shutting Down the Server

SIGHUP, Setting Parameters, pg_hba.conf 文件, 用户名映射

SIGINT, Shutting Down the Server

sign, Mathematical Functions and Operators

signal

backend processes, System Administration Functions

significant digits, Locale and Formatting

SIGQUIT, Shutting Down the Server

SIGTERM, Shutting Down the Server

silent_mode configuration parameter, Where To Log

SIMILAR TO, SIMILAR TO Regular Expressions

sin, Mathematical Functions and Operators

sleep, Delaying Execution

sliced bread

see TOAST

smallint, Integer Types

Solaris

installation on, Solaris

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

start script, Starting the Database Server

SOME, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

sorting, Sorting Rows

SPI, Server Programming Interface

examples, spi

SPI_connect, SPI_connect

SPI_copytuple, SPI_copytuple

SPI_cursor_close, SPI_cursor_close

in PL/Perl, Database Access from PL/Perl

SPI_cursor_fetch, SPI_cursor_fetch

SPI_cursor_find, SPI_cursor_find

SPI_cursor_move, SPI_cursor_move

SPI_cursor_open, SPI_cursor_open

SPI_cursor_open_with_args, SPI_cursor_open_with_args

SPI_cursor_open_with_paramlist, SPI_cursor_open_with_paramlist

SPI_exec, SPI_exec

SPI_execp, SPI_execp

SPI_execute, SPI_execute

SPI_execute_plan, SPI_execute_plan

SPI_execute_plan_with_paramlist, SPI_execute_plan_with_paramlist

SPI_execute_with_args, SPI_execute_with_args

spi_exec_prepared

in PL/Perl, Database Access from PL/Perl

spi_exec_query

in PL/Perl, Database Access from PL/Perl

spi_fetchrow

in PL/Perl, Database Access from PL/Perl

SPI_finish, SPI_finish

SPI_fname, SPI_fname

SPI_fnumber, SPI_fnumber

SPI_freeplan, SPI_freeplan

in PL/Perl, Database Access from PL/Perl

SPI_freetuple, SPI_freetuple

SPI_freetuptable, SPI_freetuptable

SPI_getargcount, SPI_getargcount

SPI_getargtypeid, SPI_getargtypeid

SPI_getbinval, SPI_getbinval

SPI_getnspname, SPI_getnspname

SPI_getrelname, SPI_getrelname

SPI_gettype, SPI_gettype

SPI_gettypeid, SPI_gettypeid

SPI_getvalue, SPI_getvalue

SPI_is_cursor_plan, SPI_is_cursor_plan

spi_lastoid, Database Access from PL/Tcl

SPI_modifytuple, SPI_modifytuple

SPI_palloc, SPI_palloc

SPI_pfree, SPI_pfree

SPI_pop, SPI_pop

SPI_prepare, SPI_prepare

in PL/Perl, Database Access from PL/Perl

SPI_prepare_cursor, SPI_prepare_cursor

SPI_prepare_params, SPI_prepare_params

SPI_push, SPI_push

spi_query

in PL/Perl, Database Access from PL/Perl

spi_query_prepared

in PL/Perl, Database Access from PL/Perl

SPI_repalloc, SPI_repalloc

SPI_returntuple, SPI_returntuple

SPI_saveplan, SPI_saveplan

SPI_scroll_cursor_fetch, SPI_scroll_cursor_fetch

SPI_scroll_cursor_move, SPI_scroll_cursor_move

split_part, String Functions and Operators

SQL/CLI, SQL Conformance

SQL/Foundation, SQL Conformance

SQL/Framework, SQL Conformance

SQL/JRT, SQL Conformance

SQL/MED, SQL Conformance

SQL/OLB, SQL Conformance

SQL/PSM, SQL Conformance

SQL/Schemata, SQL Conformance

SQL/XML, SQL Conformance

sql_inheritance configuration parameter, Previous PostgreSQL Versions

sqrt, Mathematical Functions and Operators

ssh, Secure TCP/IP Connections with SSH Tunnels

SSL, Secure TCP/IP Connections with SSL, SSL Support

with libpq, Database Connection Control Functions, Connection Status Functions

ssl configuration parameter, Security and Authentication

sslinfo, sslinfo

ssl_ciphers configuration parameter, Security and Authentication

ssl_renegotiation_limit configuration parameter, Security and Authentication

SSPI, SSPI认证

STABLE, Function Volatility Categories

standard deviation, Aggregate Functions

population, Aggregate Functions

sample, Aggregate Functions

standard_conforming_strings configuration parameter, Previous PostgreSQL Versions

standby server, High Availability, Load Balancing, and Replication

standby_mode recovery parameter, Standby server settings

START TRANSACTION, START TRANSACTION

statement_timeout configuration parameter, Statement Behavior

statement_timestamp, Date/Time Functions and Operators

statistics, Aggregate Functions, The Statistics Collector

of the planner, Statistics Used by the Planner, Updating Planner Statistics

stats_temp_directory configuration parameter, Query and Index Statistics Collector

STONITH, High Availability, Load Balancing, and Replication

storage parameters, Storage Parameters

Streaming Replication, High Availability, Load Balancing, and Replication

string

see character string

strings

backslash quotes, Previous PostgreSQL Versions

escape warning, Previous PostgreSQL Versions

standard conforming, Previous PostgreSQL Versions

string_agg, Aggregate Functions

string_to_array, Array Functions and Operators

strip, Manipulating Documents

strpos, String Functions and Operators

subquery, Aggregate Functions, Scalar Subqueries, Subqueries, Subquery Expressions

subscript, Subscripts

substr, String Functions and Operators

substring, String Functions and Operators, Binary String Functions and Operators, SIMILAR TO Regular Expressions, POSIX Regular Expressions

sum, Aggregate Functions

superuser, Accessing a Database

superuser_reserved_connections configuration parameter, Connection Settings

suppress_redundant_updates_trigger, Trigger Functions

synchronize_seqscans configuration parameter, Previous PostgreSQL Versions

synchronous commit, Asynchronous Commit

synchronous_commit configuration parameter, Settings

syntax

SQL, SQL Syntax

syslog_facility configuration parameter, Where To Log

syslog_identity configuration parameter, Where To Log

T

table, Concepts

TABLE command, SELECT

table expression, Table Expressions

table function, Table Functions

tablefunc, tablefunc

tableoid, 系统字段

tablespace, 表空间

default, Statement Behavior

temporary, Statement Behavior

tan, Mathematical Functions and Operators

target list, The Query Tree

Tcl, PL/Tcl - Tcl Procedural Language

tcp_keepalives_count configuration parameter, Connection Settings

tcp_keepalives_idle configuration parameter, Connection Settings

tcp_keepalives_interval configuration parameter, Connection Settings

template1, 创建一个数据库, 临时库

temp_buffers configuration parameter, Memory

temp_tablespaces configuration parameter, Statement Behavior

test, Regression Tests

test_parser, test_parser

text, Character Types

text search, Full Text Search

data types, Text Search Types

functions and operators, Text Search Types

indexes, GiST and GIN Index Types

threads

with libpq, Behavior in Threaded Programs

tid, Object Identifier Types

time, Date/Time Types, Times

constants, Special Values

current, Current Date/Time

output format, Date/Time Output

see also formatting

time span, Date/Time Types

time with time zone, Date/Time Types, Times

time without time zone, Date/Time Types, Times

time zone, Time Zones, Locale and Formatting

conversion, AT TIME ZONE

input abbreviations , 日期/时间配置文件

time zone data, 安装过程

time zone names, Locale and Formatting

timeofday, Date/Time Functions and Operators

timeout

client authentication, Security and Authentication

deadlock, Lock Management

timestamp, Date/Time Types, Time Stamps

timestamp with time zone, Date/Time Types, Time Stamps

timestamp without time zone, Date/Time Types, Time Stamps

timezone configuration parameter, Locale and Formatting

timezone_abbreviations configuration parameter, Locale and Formatting

TOAST, TOAST

and user-defined types, User-Defined Types

per-column storage settings, Description

versus large objects, 介绍

token, Lexical Structure

to_ascii, String Functions and Operators

to_char, Data Type Formatting Functions

and locales, 行为

to_date, Data Type Formatting Functions

to_hex, String Functions and Operators

to_number, Data Type Formatting Functions

to_timestamp, Data Type Formatting Functions

to_tsquery, Parsing Queries

to_tsvector, Parsing Documents

trace_locks configuration parameter, Developer Options

trace_lock_oidmin configuration parameter, Developer Options

trace_lock_table configuration parameter, Developer Options

trace_lwlocks configuration parameter, Developer Options

trace_notify configuration parameter, Developer Options

trace_recovery_messages configuration parameter, Developer Options

trace_sort configuration parameter, Developer Options

trace_userlocks configuration parameter, Developer Options

track_activities configuration parameter, Query and Index Statistics Collector

track_activity_query_size configuration parameter, Query and Index Statistics Collector

track_counts configuration parameter, Query and Index Statistics Collector

track_functions configuration parameter, Query and Index Statistics Collector

transaction ID

wraparound, Preventing Transaction ID Wraparound Failures

transaction isolation, Transaction Isolation

transaction isolation level, Transaction Isolation, Statement Behavior

read committed, Read Committed Isolation Level

serializable, Serializable Isolation Level

transaction log

see WAL

transaction_timestamp, Date/Time Functions and Operators

transform_null_equals configuration parameter, Platform and Client Compatibility

translate, String Functions and Operators

trigger, Pseudo-Types, Triggers

arguments for trigger functions, Overview of Trigger Behavior

for updating a derived tsvector column, Triggers for Automatic Updates

in C, Writing Trigger Functions in C

in PL/pgSQL, 触发器过程

in PL/Python, Trigger Functions

in PL/Tcl, Trigger Procedures in PL/Tcl

compared with rules, Rules versus Triggers

trigger_file recovery parameter, Standby server settings

trim, String Functions and Operators

Tru64 UNIX

shared library, Compiling and Linking Dynamically-Loaded Functions

true, Boolean Type

trunc, Mathematical Functions and Operators

TRUNCATE, TRUNCATE

trusted

PL/Perl, Trusted and Untrusted PL/Perl

tsearch2, tsearch2

tsquery (data type), tsquery

tsvector (data type), tsvector

tsvector concatenation, Manipulating Documents

ts_debug, Configuration Testing

ts_headline, Highlighting Results

ts_lexize, Dictionary Testing

ts_parse, Parser Testing

ts_rank, Ranking Search Results

ts_rank_cd, Ranking Search Results

ts_rewrite, Query Rewriting

ts_stat, Gathering Document Statistics

ts_token_type, Parser Testing

txid_current, System Information Functions

txid_current_snapshot, System Information Functions

txid_snapshot_xip, System Information Functions

txid_snapshot_xmax, System Information Functions

txid_snapshot_xmin, System Information Functions

txid_visible_in_snapshot, System Information Functions

type

see data type
polymorphic, Polymorphic Types

type cast, Numeric Constants, Type Casts

U

UESCAPE, Identifiers and Key Words, String Constants with Unicode Escapes

unaccent, unaccent, Functions

Unicode escape

in identifiers, Identifiers and Key Words

in string constants, String Constants with Unicode Escapes

UNION, Combining Queries

determination of result type, UNION, CASE, and Related Constructs

Unix domain socket, Database Connection Control Functions

UnixWare

installation on, SCO OpenServer and SCO UnixWare

IPC configuration, Shared Memory and Semaphores

shared library, Compiling and Linking Dynamically-Loaded Functions

unix_socket_directory configuration parameter, Connection Settings

unix_socket_group configuration parameter, Connection Settings

unix_socket_permissions configuration parameter, Connection Settings

UNLISTEN, UNLISTEN

unnest, Array Functions and Operators

UPDATE, Updates, UPDATE

update_process_title configuration parameter, Query and Index Statistics Collector

upgrading, 升级

upper, String Functions and Operators

and locales, 行为

user

current, System Information Functions

UUID, UUID Type, 安装过程

uuid-ossp, uuid-ossp

V

vacuum, Routine Vacuuming, VACUUM

vacuumdb, vacuumdb

vacuumlo, vacuumlo

vacuum_cost_delay configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_limit configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_dirty configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_hit configuration parameter, Cost-Based Vacuum Delay

vacuum_cost_page_miss configuration parameter, Cost-Based Vacuum Delay

vacuum_defer_cleanup_age configuration parameter, Streaming Replication

vacuum_freeze_min_age configuration parameter, Statement Behavior

vacuum_freeze_table_age configuration parameter, Statement Behavior

value expression, Value Expressions

VALUES, VALUES Lists, VALUES

determination of result type, UNION, CASE, and Related Constructs

varchar, Character Types

variadic function, SQL Functions with Variable Numbers of Arguments

variance, Aggregate Functions

population, Aggregate Functions

sample, Aggregate Functions

version, Accessing a Database, System Information Functions

view

implementation through rules, Views and the Rule System

updating, Cooperation with Views

Visibility Map, Visibility Map

VM

see Visibility Map

void, Pseudo-Types

VOLATILE, Function Volatility Categories

volatility

functions, Function Volatility Categories

VPATH, 安装过程

W

WAL, Reliability and the Write-Ahead Log

wal_block_size configuration parameter, Preset Options

wal_buffers configuration parameter, Settings

wal_debug configuration parameter, Developer Options

wal_keep_segments configuration parameter, Streaming Replication

wal_level configuration parameter, Settings

wal_segment_size configuration parameter, Preset Options

wal_sender_delay configuration parameter, Streaming Replication

wal_sync_method configuration parameter, Settings

wal_writer_delay configuration parameter, Settings

warm standby, High Availability, Load Balancing, and Replication

WHERE, The WHERE Clause

where to log, Where To Log

WHILE

in PL/pgSQL, WHILE

width, Geometric Functions and Operators

width_bucket, Mathematical Functions and Operators

window function

built-in, Window Functions

invocation, Window Function Calls

order of execution, Window Function Processing

WITH

in SELECT, WITH Queries (Common Table Expressions), SELECT

witness server, High Availability, Load Balancing, and Replication

work_mem configuration parameter, Memory

X

xid, Object Identifier Types
xmax, 系统字段
xmin, 系统字段
XML, XML Type
XML export, Mapping Tables to XML
XML option, Creating XML Values, Statement Behavior
xml2, xml2
xmlagg, xmlagg, Aggregate Functions
xmlbinary configuration parameter, Statement Behavior
xmlcomment, xmlcomment
xmlconcat, xmlconcat
xmlelement, xmlelement
xmlforest, xmlforest
xmloption configuration parameter, Statement Behavior
xmlparse, Creating XML Values
xmlpi, xmlpi
xmlroot, xmlroot
xmlserialize, Creating XML Values
XPath, Processing XML

Y

yacc, 要求

Z

zero_damaged_pages configuration parameter, Developer Options
zlib, 要求, 安装过程

Vorheriger Artikel： Nächster Artikel：