PostgreSQL 手册
目录搜索
前言何为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和OFFSET7.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 BY11.5. 组合多个索引11.6. 唯一索引11.7. 表达式上的索引11.8. 部分索引11.9. 操作类和操作簇11.10. 检查索引的使用章12. Full Text Search12.1. Introduction12.2. Tables and Indexes12.3. Controlling Text Search12.4. Additional Features12.5. Parsers12.6. Dictionaries12.7. Configuration Example12.8. Testing and Debugging Text Search12.9. GiST and GIN Index Types12.10. psql Support12.11. Limitations12.12. Migration from Pre-8.3 Text Search章13. 并发控制13.1. 介绍13.2. 事务隔离13.3. 明确锁定13.4. 应用层数据完整性检查13.5. 锁和索引章14. 性能提升技巧14.1. 使用EXPLAIN14.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 Windows16.1. Building with Visual C++ or the Platform SDK16.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 Tests30.1. Running the Tests30.2. Test Evaluation30.3. Variant Comparison Files30.4. Test Coverage ExaminationIV. 客户端接口章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 C33.1. The Concept33.2. Connecting to the Database Server33.3. Closing a Connection33.4. Running SQL Commands33.5. Choosing a Connection33.6. Using Host Variables33.7. Dynamic SQL33.8. pgtypes library33.9. Using Descriptor Areas33.10. Informix compatibility mode33.11. Error Handling33.12. Preprocessor directives33.13. Processing Embedded SQL Programs33.14. Library Functions33.15. Internals章34. 信息模式34.1. 关于这个模式34.2. 数据类型34.3. information_schema_catalog_name34.4. administrable_role_authorizations34.5. applicable_roles34.6. attributes34.7. check_constraint_routine_usage34.8. check_constraints34.9. column_domain_usage34.10. column_privileges34.11. column_udt_usage34.12. 字段34.13. constraint_column_usage34.14. constraint_table_usage34.15. data_type_privileges34.16. domain_constraints34.18. domains34.17. domain_udt_usage34.19. element_types34.20. enabled_roles34.21. foreign_data_wrapper_options34.22. foreign_data_wrappers34.23. foreign_server_options34.24. foreign_servers34.25. key_column_usage34.26. parameters34.27. referential_constraints34.28. role_column_grants34.29. role_routine_grants34.30. role_table_grants34.31. role_usage_grants34.32. routine_privileges34.33. routines34.34. schemata34.35. sequences34.36. sql_features34.37. sql_implementation_info34.38. sql_languages34.39. sql_packages34.40. sql_parts34.41. sql_sizing34.42. sql_sizing_profiles34.43. table_constraints34.44. table_privileges34.45. tables34.46. triggered_update_columns34.47. 触发器34.48. usage_privileges34.49. user_mapping_options34.50. user_mappings34.51. view_column_usage34.52. view_routine_usage34.53. view_table_usage34.54. 视图V. 服务器端编程章35. 扩展SQL35.1. 扩展性是如何实现的35.2. PostgreSQL类型系统35.3. User-Defined Functions35.4. Query Language (SQL) Functions35.5. Function Overloading35.6. Function Volatility Categories35.7. Procedural Language Functions35.8. Internal Functions35.9. C-Language Functions35.10. User-Defined Aggregates35.11. User-Defined Types35.12. User-Defined Operators35.13. Operator Optimization Information35.14. Interfacing Extensions To Indexes35.15. 用C++扩展章36. 触发器36.1. 触发器行为概述36.3. 用 C 写触发器36.2. 数据改变的可视性36.4. 一个完整的例子章37. 规则系统37.1. The Query Tree37.2. 视图和规则系统37.3. 在INSERT，UPDATE和DELETE上的规则37.4. 规则和权限37.5. 规则和命令状态37.6. 规则与触发器得比较章38. Procedural Languages38.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 Hood39.11. 开发PL/pgSQL的一些提示39.12. 从OraclePL/SQL 进行移植章40. PL/Tcl - Tcl Procedural Language40.1. Overview40.2. PL/Tcl Functions and Arguments40.3. Data Values in PL/Tcl40.4. Global Data in PL/Tcl40.5. Database Access from PL/Tcl40.6. Trigger Procedures in PL/Tcl40.7. Modules and the unknown command40.8. Tcl Procedure Names章41. PL/Perl - Perl Procedural Language41.1. PL/Perl Functions and Arguments41.2. Data Values in PL/Perl41.3. Built-in Functions41.4. Global Values in PL/Perl41.6. PL/Perl Triggers41.5. Trusted and Untrusted PL/Perl41.7. PL/Perl Under the Hood章42. PL/Python - Python Procedural Language42.1. Python 2 vs. Python 342.2. PL/Python Functions42.3. Data Values42.4. Sharing Data42.5. Anonymous Code Blocks42.6. Trigger Functions42.7. Database Access42.8. Utility Functions42.9. Environment Variables章43. Server Programming Interface43.1. Interface FunctionsSpi-spi-connectSpi-spi-finishSpi-spi-pushSpi-spi-popSpi-spi-executeSpi-spi-execSpi-spi-execute-with-argsSpi-spi-prepareSpi-spi-prepare-cursorSpi-spi-prepare-paramsSpi-spi-getargcountSpi-spi-getargtypeidSpi-spi-is-cursor-planSpi-spi-execute-planSpi-spi-execute-plan-with-paramlistSpi-spi-execpSpi-spi-cursor-openSpi-spi-cursor-open-with-argsSpi-spi-cursor-open-with-paramlistSpi-spi-cursor-findSpi-spi-cursor-fetchSpi-spi-cursor-moveSpi-spi-scroll-cursor-fetchSpi-spi-scroll-cursor-moveSpi-spi-cursor-closeSpi-spi-saveplan43.2. Interface Support FunctionsSpi-spi-fnameSpi-spi-fnumberSpi-spi-getvalueSpi-spi-getbinvalSpi-spi-gettypeSpi-spi-gettypeidSpi-spi-getrelnameSpi-spi-getnspname43.3. Memory ManagementSpi-spi-pallocSpi-reallocSpi-spi-pfreeSpi-spi-copytupleSpi-spi-returntupleSpi-spi-modifytupleSpi-spi-freetupleSpi-spi-freetupletableSpi-spi-freeplan43.4. Visibility of Data Changes43.5. ExamplesVI. 参考手册I. SQL命令Sql-abortSql-alteraggregateSql-alterconversionSql-alterdatabaseSql-alterdefaultprivilegesSql-alterdomainSql-alterforeigndatawrapperSql-alterfunctionSql-altergroupSql-alterindexSql-alterlanguageSql-alterlargeobjectSql-alteroperatorSql-alteropclassSql-alteropfamilySql-alterroleSql-alterschemaSql-altersequenceSql-alterserverSql-altertableSql-altertablespaceSql-altertsconfigSql-altertsdictionarySql-altertsparserSql-altertstemplateSql-altertriggerSql-altertypeSql-alteruserSql-alterusermappingSql-alterviewSql-analyzeSql-beginSql-checkpointSql-closeSql-clusterSql-commentSql-commitSql-commit-preparedSql-copySql-createaggregateSql-createcastSql-createconstraintSql-createconversionSql-createdatabaseSql-createdomainSql-createforeigndatawrapperSql-createfunctionSql-creategroupSql-createindexSql-createlanguageSql-createoperatorSql-createopclassSql-createopfamilySql-createroleSql-createruleSql-createschemaSql-createsequenceSql-createserverSql-createtableSql-createtableasSql-createtablespaceSql-createtsconfigSql-createtsdictionarySql-createtsparserSql-createtstemplateSql-createtriggerSql-createtypeSql-createuserSql-createusermappingSql-createviewSql-deallocateSql-declareSql-deleteSql-discardSql-doSql-dropaggregateSql-dropcastSql-dropconversionSql-dropdatabaseSql-dropdomainSql-dropforeigndatawrapperSql-dropfunctionSql-dropgroupSql-dropindexSql-droplanguageSql-dropoperatorSql-dropopclassSql-dropopfamilySql-drop-ownedSql-droproleSql-dropruleSql-dropschemaSql-dropsequenceSql-dropserverSql-droptableSql-droptablespaceSql-droptsconfigSql-droptsdictionarySql-droptsparserSql-droptstemplateSql-droptriggerSql-droptypeSql-dropuserSql-dropusermappingSql-dropviewSql-endSql-executeSql-explainSql-fetchSql-grantSql-insertSql-listenSql-loadSql-lockSql-moveSql-notifySql-prepareSql-prepare-transactionSql-reassign-ownedSql-reindexSql-release-savepointSql-resetSql-revokeSql-rollbackSql-rollback-preparedSql-rollback-toSql-savepointSql-selectSql-selectintoSql-setSql-set-constraintsSql-set-roleSql-set-session-authorizationSql-set-transactionSql-showSql-start-transactionSql-truncateSql-unlistenSql-updateSql-vacuumSql-valuesII. 客户端应用程序App-clusterdbApp-createdbApp-createlangApp-createuserApp-dropdbApp-droplangApp-dropuserApp-ecpgApp-pgconfigApp-pgdumpApp-pg-dumpallApp-pgrestoreApp-psqlApp-reindexdbApp-vacuumdbIII. PostgreSQL服务器应用程序App-initdbApp-pgcontroldataApp-pg-ctlApp-pgresetxlogApp-postgresApp-postmasterVII. 内部章44. PostgreSQL内部概览44.1. 查询路径44.2. 连接是如何建立起来的44.3. 分析器阶段44.4. ThePostgreSQL规则系统44.5. 规划器/优化器44.6. 执行器章45. 系统表45.1. 概述45.2. pg_aggregate45.3. pg_am45.4. pg_amop45.5. pg_amproc45.6. pg_attrdef45.7. pg_attribute45.8. pg_authid45.9. pg_auth_members45.10. pg_cast45.11. pg_class45.12. pg_constraint45.13. pg_conversion45.14. pg_database45.15. pg_db_role_setting45.16. pg_default_acl45.17. pg_depend45.18. pg_description45.19. pg_enum45.20. pg_foreign_data_wrapper45.21. pg_foreign_server45.22. pg_index45.23. pg_inherits45.24. pg_language45.25. pg_largeobject45.26. pg_largeobject_metadata45.27. pg_namespace45.28. pg_opclass45.29. pg_operator45.30. pg_opfamily45.31. pg_pltemplate45.32. pg_proc45.33. pg_rewrite45.34. pg_shdepend45.35. pg_shdescription45.36. pg_statistic45.37. pg_tablespace45.38. pg_trigger45.39. pg_ts_config45.40. pg_ts_config_map45.41. pg_ts_dict45.42. pg_ts_parser45.43. pg_ts_template45.44. pg_type45.45. pg_user_mapping45.46. System Views45.47. pg_cursors45.48. pg_group45.49. pg_indexes45.50. pg_locks45.51. pg_prepared_statements45.52. pg_prepared_xacts45.53. pg_roles45.54. pg_rules45.55. pg_settings45.56. pg_shadow45.57. pg_stats45.58. pg_tables45.59. pg_timezone_abbrevs45.60. pg_timezone_names45.61. pg_user45.62. pg_user_mappings45.63. pg_views章46. Frontend/Backend Protocol46.1. Overview46.2. Message Flow46.3. Streaming Replication Protocol46.4. Message Data Types46.5. Message Formats46.6. Error and Notice Message Fields46.7. Summary of Changes since Protocol 2.047. PostgreSQL Coding Conventions47.1. Formatting47.2. Reporting Errors Within the Server47.3. Error Message Style Guide章48. Native Language Support48.1. For the Translator48.2. For the Programmer章49. Writing A Procedural Language Handler章50. Genetic Query Optimizer50.1. Query Handling as a Complex Optimization Problem50.2. Genetic Algorithms50.3. Genetic Query Optimization (GEQO) in PostgreSQL50.4. Further Reading章51. 索引访问方法接口定义51.1. 索引的系统表记录51.2. 索引访问方法函数51.3. 索引扫描51.4. 索引锁的考量51.5. 索引唯一性检查51.6. 索引开销估计函数章52. GiST Indexes52.1. Introduction52.2. Extensibility52.3. Implementation52.4. Examples52.5. Crash Recovery章53. GIN Indexes53.1. Introduction53.2. Extensibility53.3. Implementation53.4. GIN tips and tricks53.5. Limitations53.6. Examples章54. 数据库物理存储54.1. 数据库文件布局54.2. TOAST54.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 ConformanceD.1. Supported FeaturesD.2. Unsupported FeaturesE. Release NotesRelease-0-01Release-0-02Release-0-03Release-1-0Release-1-01Release-1-02Release-1-09Release-6-0Release-6-1Release-6-1-1Release-6-2Release-6-2-1Release-6-3Release-6-3-1Release-6-3-2Release-6-4Release-6-4-1Release-6-4-2Release-6-5Release-6-5-1Release-6-5-2Release-6-5-3Release-7-0Release-7-0-1Release-7-0-2Release-7-0-3Release-7-1Release-7-1-1Release-7-1-2Release-7-1-3Release-7-2Release-7-2-1Release-7-2-2Release-7-2-3Release-7-2-4Release-7-2-5Release-7-2-6Release-7-2-7Release-7-2-8Release-7-3Release-7-3-1Release-7-3-10Release-7-3-11Release-7-3-12Release-7-3-13Release-7-3-14Release-7-3-15Release-7-3-16Release-7-3-17Release-7-3-18Release-7-3-19Release-7-3-2Release-7-3-20Release-7-3-21Release-7-3-3Release-7-3-4Release-7-3-5Release-7-3-6Release-7-3-7Release-7-3-8Release-7-3-9Release-7-4Release-7-4-1Release-7-4-10Release-7-4-11Release-7-4-12Release-7-4-13Release-7-4-14Release-7-4-15Release-7-4-16Release-7-4-17Release-7-4-18Release-7-4-19Release-7-4-2Release-7-4-20Release-7-4-21Release-7-4-22Release-7-4-23Release-7-4-24Release-7-4-25Release-7-4-26Release-7-4-27Release-7-4-28Release-7-4-29Release-7-4-3Release-7-4-30Release-7-4-4Release-7-4-5Release-7-4-6Release-7-4-7Release-7-4-8Release-7-4-9Release-8-0Release-8-0-1Release-8-0-10Release-8-0-11Release-8-0-12Release-8-0-13Release-8-0-14Release-8-0-15Release-8-0-16Release-8-0-17Release-8-0-18Release-8-0-19Release-8-0-2Release-8-0-20Release-8-0-21Release-8-0-22Release-8-0-23Release-8-0-24Release-8-0-25Release-8-0-26Release-8-0-3Release-8-0-4Release-8-0-5Release-8-0-6Release-8-0-7Release-8-0-8Release-8-0-9Release-8-1Release-8-1-1Release-8-1-10Release-8-1-11Release-8-1-12Release-8-1-13Release-8-1-14Release-8-1-15Release-8-1-16Release-8-1-17Release-8-1-18Release-8-1-19Release-8-1-2Release-8-1-20Release-8-1-21Release-8-1-22Release-8-1-23Release-8-1-3Release-8-1-4Release-8-1-5Release-8-1-6Release-8-1-7Release-8-1-8Release-8-1-9Release-8-2Release-8-2-1Release-8-2-10Release-8-2-11Release-8-2-12Release-8-2-13Release-8-2-14Release-8-2-15Release-8-2-16Release-8-2-17Release-8-2-18Release-8-2-19Release-8-2-2Release-8-2-20Release-8-2-21Release-8-2-3Release-8-2-4Release-8-2-5Release-8-2-6Release-8-2-7Release-8-2-8Release-8-2-9Release-8-3Release-8-3-1Release-8-3-10Release-8-3-11Release-8-3-12Release-8-3-13Release-8-3-14Release-8-3-15Release-8-3-2Release-8-3-3Release-8-3-4Release-8-3-5Release-8-3-6Release-8-3-7Release-8-3-8Release-8-3-9Release-8-4Release-8-4-1Release-8-4-2Release-8-4-3Release-8-4-4Release-8-4-5Release-8-4-6Release-8-4-7Release-8-4-8Release-9-0Release-9-0-1Release-9-0-2Release-9-0-3Release-9-0-4F. 额外提供的模块F.1. adminpackF.2. auto_explainF.3. btree_ginF.4. btree_gistF.5. chkpassF.6. citextF.7. cubeF.8. dblinkContrib-dblink-connectContrib-dblink-connect-uContrib-dblink-disconnectContrib-dblinkContrib-dblink-execContrib-dblink-openContrib-dblink-fetchContrib-dblink-closeContrib-dblink-get-connectionsContrib-dblink-error-messageContrib-dblink-send-queryContrib-dblink-is-busyContrib-dblink-get-notifyContrib-dblink-get-resultContrib-dblink-cancel-queryContrib-dblink-get-pkeyContrib-dblink-build-sql-insertContrib-dblink-build-sql-deleteContrib-dblink-build-sql-updateF.9. dict_intF.10. dict_xsynF.11. earthdistanceF.12. fuzzystrmatchF.13. hstoreF.14. intaggF.15. intarrayF.16. isnF.17. loF.18. ltreeF.19. oid2nameF.20. pageinspectF.21. passwordcheckF.22. pg_archivecleanupF.23. pgbenchF.24. pg_buffercacheF.25. pgcryptoF.26. pg_freespacemapF.27. pgrowlocksF.28. pg_standbyF.29. pg_stat_statementsF.30. pgstattupleF.31. pg_trgmF.32. pg_upgradeF.33. segF.34. spiF.35. sslinfoF.36. tablefuncF.37. test_parserF.38. tsearch2F.39. unaccentF.40. uuid-osspF.41. vacuumloF.42. xml2G. 外部项目G.1. 客户端接口G.2. 过程语言G.3. 扩展H. The Source Code RepositoryH.1. Getting The Source Via GitI. 文档I.1. DocBookI.2. 工具集I.3. 制作文档I.4. 文档写作I.5. 风格指导J. 首字母缩略词参考书目BookindexIndex

©
本文档使用 php.cn手册 发布

文字

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