PostgreSQL 手册
简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
目錄 搜尋
前言 何为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

©
本文檔使用 php中文網手册 發布

文字

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, 要求, 安装过程
上一篇： 下一篇：