PostgreSQL 18 中文参考文档（未翻译部分保留英文）🌐 切换到英文原版 →
Index
上一页 上一级PostgreSQL 18.6 参考文档首页 

Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X

Symbols

$, 位置参数
$libdir/plugins, Description
.pgpass, The Password File
.pg_service.conf, The Connection Service File
::, 类型转换
_PG_archive_module_init, 初始化函数
_PG_oauth_validator_module_init, 初始化函数
下标, 下标
不可重复读, 事务隔离
中位数, 聚合表达式
(see also 百分位数)
串行化失败, 串行化失败处理
串行化异常, 事务隔离
主键, 主键
事件触发器, 事件触发器
事务, 事务
事务 ID 回卷, 防范事务 ID 回卷故障
事务日志 (see WAL)
事务隔离, 事务隔离
仅索引扫描, 仅索引扫描与覆盖索引
伪类型, 伪类型
位串, 位串常量
常量, 位串常量
位串类型, 位串类型
位图扫描, 组合多个索引
例行维护, 日常数据库维护任务
依赖关系, 依赖关系跟踪
值表达式, 值表达式
全文搜索, 全文搜索
全文搜索类型, 文本搜索类型
关系, 核心概念
关系型数据库, 核心概念
关键字, 标识符与关键字
语法, 标识符与关键字
关闭服务器, 关闭服务器
冲突处理, 冲突处理
逻辑复制, 冲突处理
几何类型, 几何类型
函数, 函数
位置表示法, 使用位置表示法
具名表示法, 使用具名表示法
混合表示法, 使用混合表示法
调用, 函数调用
调用时的类型推导, 函数
分区, 表分区
列, 核心概念, 表基础
列引用, 列引用
创建数据库特权, 角色属性
创建角色特权, 角色属性
删除, 删除数据
别名, 表与列别名, 列别名
在 FROM 子句中, 表与列别名
查询中的表别名, 表之间的连接查询
输出列别名, 列别名
区域设置, 区域设置
升级, 集群大版本升级
单引号
转义, 字符串常量
即时编译 (see JIT)
历史, PostgreSQL 简史
PostgreSQL 的历史, PostgreSQL 简史
参数
语法, 位置参数
反斜杠转义, C 风格转义字符串常量
可串行化, 可串行化隔离级别
可串行化快照隔离, 简介
可重复读, 可重复读隔离级别
同步复制, 同步复制
同步提交, 异步提交
名称, 标识符与关键字
语法, 标识符与关键字
后台工作进程, 后台工作进程
咨询锁, 咨询锁
唯一索引, 唯一索引
唯一约束, 唯一约束
回归测试, 回归测试
域, 域类型
基于时间点恢复, 备份与恢复
基类型, PostgreSQL 类型系统
备份, 备份与恢复
复制, 高可用、负载均衡与复制
复制槽, 流复制与复制槽
复制源, 复制进度跟踪与复制源
复制特权, 角色属性
复制进度跟踪, 复制进度跟踪与复制源
复合类型, PostgreSQL 类型系统
构造器, 行构造器
外部数据包装器, 外部数据
外部表, 外部数据
外键, 外键, 外键
多列索引, 多列索引
多版本并发控制, 简介
大对象, 大对象
大小写敏感性
SQL 命令的大小写, 标识符与关键字
子查询, 聚合函数, 标量子查询, 子查询
在 FROM 子句中, 子查询
字段选择, 字段选择
字符串, 字符串常量
常量, 字符串常量
字符类型, 字符类型
字符集, 字符集支持与多字节编码
安装, 从源码安装
二进制包, 从二进制包安装
客户端认证, 客户端认证
密码, 角色属性
层次型数据库, 核心概念
常量, 常量
并发控制, 并发控制
并行查询, 并行查询
幻读, 事务隔离
异步提交, 异步提交
引号
标识符中的引号, 标识符与关键字
引用完整性, 外键, 外键
归档模块, 归档模块
性能, 性能调优建议
扩展, 将相关对象打包为扩展插件
扩展 SQL, 扩展 SQL
扩展统计信息, 扩展统计信息
批量加载, 批量数据加载
括号, 值表达式
排序规则, 排序规则支持
排除约束, 排除约束
插入, 插入数据
操作符类, 操作符类与操作符族
故障转移, 高可用、负载均衡与复制, 故障转移
数值
常量, 数值常量
数值类型, 数值类型
数据库, 创建数据库, 管理数据库
创建, 创建数据库
数据库集群, 核心概念, 创建数据库集群
数据类型, 数据类型, 类型转换
常量, 其他类型的常量
类别, 概述
类型转换, 类型转换
转换, 类型转换
数组
构造器, 数组构造器
文本搜索, 全文搜索
文档, 什么是文档？
全文搜索, 什么是文档？
日志维护, 日志文件维护
日期/时间类型, 日期/时间类型
时间线, 时间线（Timelines）
更新, 更新数据
有序集聚合, 聚合表达式
权限, 权限
枚举类型, 枚举类型
查询, 查询数据表, 查询
查询树, 查询树结构剖析
查询计划, 使用 EXPLAIN
标识列, 标识列
标识符, 标识符与关键字
语法, 标识符与关键字
长度限制, 标识符与关键字
标量 (see 表达式)
校验和, 数据校验和
检查索引使用, 检查索引的使用情况
检查约束, 检查约束
模式, 模式, 概述
死锁, 死锁
注释, 注释
SQL 中的注释, 注释
流复制, 流复制与复制槽
测试, 回归测试
测试覆盖率, 代码测试覆盖率检验
热备用, 热备用
版本查询, 访问数据库
物化视图, 物化视图
生成列, 生成列
用户, 数据库角色
用户名映射, 用户名映射
登录权限, 角色属性
监控, 监控数据库活动
数据库活动, 监控数据库活动
相关性打分, 对搜索结果进行排序
磁盘空间监控, 监控磁盘空间使用
空值
默认值, 默认值
窗口函数, 窗口函数, 窗口函数调用, 窗口函数处理
在查询中的执行时序, 窗口函数处理
调用, 窗口函数调用
类型 (see 数据类型)
类型转换, 数值常量, 类型转换
系统列, 系统列
索引, 索引, 索引与 ORDER BY, 锁定与索引
B-Tree, B-Tree
BRIN, BRIN
GIN, GIN
GiST, GiST
SP-GiST, SP-GiST
与 ORDER BY, 索引与 ORDER BY
哈希, Hash
锁定, 锁定与索引
约束, 约束
名称, 检查约束
检查, 检查约束
绕过行级安全, 角色属性
统计信息, 优化器使用的统计信息, 累积统计视图系统
优化器统计信息, 优化器使用的统计信息
活动监控, 累积统计视图系统
继承, 表继承, 继承
继承特权, 角色属性
维护, 日常数据库维护任务
编码, 字符集支持与多字节编码
网络地址类型, 网络地址类型
美元符界定, 美元符界定字符串常量
聚合函数, 聚合函数, 聚合表达式
调用, 聚合表达式
脏读, 事务隔离
自动清理, 自动清理守护进程
行, 核心概念, 表基础
行安全性, 行安全性策略
行类型
构造器, 行构造器
表, 核心概念, 表基础
创建, 表基础
删除, 表基础
表函数, 表函数
表分区, 表分区
表示法, 调用函数
函数, 调用函数
表空间, 表空间
表表达式, 表表达式
表达式, 值表达式
求值顺序, 表达式求值规则
语法, 值表达式
表达式索引, 表达式索引
覆盖索引, 仅索引扫描与覆盖索引
规则与触发器对比, 规则与触发器的对比
规则系统, 规则系统
视图, 视图, 视图与规则系统
基于规则的实现, 视图与规则系统
角色, 数据库角色
角色成员关系, 角色成员关系
触发器, 触发器
记号, 词法结构
读已提交, 读已提交隔离级别
负载均衡, 高可用、负载均衡与复制
超级用户, 访问数据库, 角色属性
转义字符串语法, C 风格转义字符串常量
过程语言, 过程语言
运算符, 运算符, 运算符优先级, 运算符
优先级, 运算符优先级
类型推导, 运算符
语法, 运算符
调用, 运算符调用
连接, 表之间的连接查询, 连接表
外连接, 表之间的连接查询
自连接, 表之间的连接查询
连接限制, 角色属性
连接顺序, 用显式连接子句控制规划器
控制优化器, 用显式连接子句控制规划器
连续归档, 备份与恢复
选择列表, 选择列表
递归查询, 递归查询
逻辑解码, 逻辑解码
部分索引, 部分索引
配置
服务器配置, 服务器配置
重复项, 查询数据表
锁定, 显式锁定
锁监控, 查看锁信息
集群
数据库集群 (see 数据库集群)
非持久性设置, 非持久性设置
非空约束, 非空约束
面向对象数据库, 核心概念
预定义角色, 预定义角色
高可用, 高可用、负载均衡与复制
默认值, 默认值

A

abbrev, Network Address Functions and Operators
ABORT, ABORT
abs, Mathematical Functions and Operators
aclcontains, Access Privilege Inquiry Functions
acldefault, Access Privilege Inquiry Functions
aclexplode, Access Privilege Inquiry Functions
aclitemeq, Access Privilege Inquiry Functions
acos, Mathematical Functions and Operators
acosd, Mathematical Functions and Operators
acosh, Mathematical Functions and Operators
administration tools
externally maintained, Administration Tools
age, Date/Time Functions and Operators, Transaction ID and Snapshot Information Functions
aggregate function, Aggregate Functions
built-in, Aggregate Functions
akeys, hstore Operators and Functions
ALL, Subquery Expressions, Row and Array Comparisons
ALTER AGGREGATE, ALTER AGGREGATE
ALTER COLLATION, ALTER COLLATION
ALTER CONVERSION, ALTER CONVERSION
ALTER DATABASE, ALTER DATABASE
ALTER DEFAULT PRIVILEGES, ALTER DEFAULT PRIVILEGES
ALTER DOMAIN, ALTER DOMAIN
ALTER EVENT TRIGGER, ALTER EVENT TRIGGER
ALTER EXTENSION, ALTER EXTENSION
ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE, ALTER FOREIGN TABLE
ALTER FUNCTION, ALTER FUNCTION
ALTER GROUP, ALTER GROUP
ALTER INDEX, ALTER INDEX
ALTER LANGUAGE, ALTER LANGUAGE
ALTER LARGE OBJECT, ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW, ALTER MATERIALIZED VIEW
ALTER OPERATOR, ALTER OPERATOR
ALTER OPERATOR CLASS, ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY, ALTER OPERATOR FAMILY
ALTER POLICY, ALTER POLICY
ALTER PROCEDURE, ALTER PROCEDURE
ALTER PUBLICATION, ALTER PUBLICATION
ALTER ROLE, ALTER ROLE
ALTER ROUTINE, ALTER ROUTINE
ALTER RULE, ALTER RULE
ALTER SCHEMA, ALTER SCHEMA
ALTER SEQUENCE, ALTER SEQUENCE
ALTER SERVER, ALTER SERVER
ALTER STATISTICS, ALTER STATISTICS
ALTER SUBSCRIPTION, ALTER SUBSCRIPTION
ALTER SYSTEM, ALTER SYSTEM
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
ALTER_REPLICATION_SLOT, Streaming Replication Protocol
amcheck, amcheck — tools to verify table and index consistency
ANALYZE, ANALYZE
AND (operator), Logical Operators
anonymous code blocks, DO
ANY, Aggregate Functions, Subquery Expressions, Row and Array Comparisons
any_value, Aggregate Functions
applicable role, applicable_roles
area, Geometric Functions and Operators
armor, armor(), dearmor()
ARRAY, 数组构造器
array_agg, Aggregate Functions, 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_position, Array Functions and Operators
array_positions, Array Functions and Operators
array_prepend, Array Functions and Operators
array_remove, Array Functions and Operators
array_replace, Array Functions and Operators
array_reverse, Array Functions and Operators
array_sample, Array Functions and Operators
array_shuffle, Array Functions and Operators
array_sort, Array Functions and Operators
array_to_json, Processing and Creating JSON Data
array_to_string, Array Functions and Operators
array_to_tsvector, Text Search Functions and Operators
array_upper, Array Functions and Operators
ascii, String Functions and Operators
asin, Mathematical Functions and Operators
asind, Mathematical Functions and Operators
asinh, Mathematical Functions and Operators
ASSERT
in PL/pgSQL, Checking Assertions
assertions
in PL/pgSQL, Checking Assertions
Asynchronous I/O, Glossary
AT LOCAL, AT TIME ZONE and AT LOCAL
AT TIME ZONE, AT TIME ZONE and AT LOCAL
atan, Mathematical Functions and Operators
atan2, Mathematical Functions and Operators
atan2d, Mathematical Functions and Operators
atand, Mathematical Functions and Operators
atanh, Mathematical Functions and Operators
auth_delay, auth_delay — pause on authentication failure
auth_delay.milliseconds configuration parameter, Configuration Parameters
autocommit
psql, Variables
autosummarize storage parameter, Index Storage Parameters
autovacuum, 自动清理进程配置
autovacuum_analyze_scale_factor
storage parameter, Storage Parameters
autovacuum_analyze_threshold
storage parameter, Storage Parameters
autovacuum_enabled storage parameter, Storage Parameters
autovacuum_freeze_max_age
storage parameter, Storage Parameters
autovacuum_freeze_min_age storage parameter, Storage Parameters
autovacuum_freeze_table_age storage parameter, Storage Parameters
autovacuum_multixact_freeze_max_age
storage parameter, Storage Parameters
autovacuum_multixact_freeze_min_age storage parameter, Storage Parameters
autovacuum_multixact_freeze_table_age storage parameter, Storage Parameters
autovacuum_vacuum_cost_delay
storage parameter, Storage Parameters
autovacuum_vacuum_cost_limit
storage parameter, Storage Parameters
autovacuum_vacuum_insert_scale_factor
storage parameter, Storage Parameters
autovacuum_vacuum_insert_threshold
storage parameter, Storage Parameters
autovacuum_vacuum_max_threshold
storage parameter, Storage Parameters
autovacuum_vacuum_scale_factor
storage parameter, Storage Parameters
autovacuum_vacuum_threshold
storage parameter, Storage Parameters
auto_explain, auto_explain — log execution plans of slow queries
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_level 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_parameter_max_length configuration parameter, Configuration Parameters
auto_explain.log_settings configuration parameter, Configuration Parameters
auto_explain.log_timing configuration parameter, Configuration Parameters
auto_explain.log_triggers configuration parameter, Configuration Parameters
auto_explain.log_verbose configuration parameter, Configuration Parameters
auto_explain.log_wal configuration parameter, Configuration Parameters
auto_explain.sample_rate configuration parameter, Configuration Parameters
avals, hstore Operators and Functions
average, Aggregate Functions
avg, Aggregate Functions

B

backup, Backup Control Functions
Backup Manifest, Backup Manifest Format
base64 format, Binary String Functions and Operators
basebackup_to_shell, basebackup_to_shell — example "shell" pg_basebackup module
basebackup_to_shell.command configuration parameter, Configuration Parameters
basebackup_to_shell.required_role configuration parameter, Configuration Parameters
BASE_BACKUP, Streaming Replication Protocol
basic_archive, basic_archive — an example WAL archive module
basic_archive.archive_directory configuration parameter, Configuration Parameters
batch mode, Pipeline Mode
in libpq, Pipeline Mode
BEGIN, BEGIN
BETWEEN, Comparison Functions and Operators
BETWEEN SYMMETRIC, Comparison Functions and Operators
bigint, 数值常量
binary data, Binary String Functions and Operators
functions, Binary String Functions and Operators
binary string
concatenation, Binary String Functions and Operators
converting to character string, Binary String Functions and Operators
length, Binary String Functions and Operators
bit string
length, Bit String Functions and Operators
bit strings, Bit String Functions and Operators
functions, Bit String Functions and Operators
bit_and, Aggregate Functions
bit_count, Binary String Functions and Operators, Bit String Functions and Operators
bit_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
bit_or, Aggregate Functions
bit_xor, Aggregate Functions
BLOB (see 大对象)
bloom, bloom — bloom filter index access method
boolean, 布尔类型
Boolean
operators (see operators, logical)
bool_and, Aggregate Functions
bool_or, Aggregate Functions
bound_box, Geometric Functions and Operators
box, Geometric Functions and Operators
brin_desummarize_range, Index Maintenance Functions
brin_metapage_info, BRIN Functions
brin_page_items, BRIN Functions
brin_page_type, BRIN Functions
brin_revmap_data, BRIN Functions
brin_summarize_new_values, Index Maintenance Functions
brin_summarize_range, Index Maintenance Functions
broadcast, Network Address Functions and Operators
btree_gin, btree_gin — GIN operator classes with B-tree behavior
btree_gist, btree_gist — GiST operator classes with B-tree behavior
btrim, String Functions and Operators, Binary String Functions and Operators
bt_index_check, Functions
bt_index_parent_check, Functions
bt_metap, B-Tree Functions
bt_multi_page_stats, B-Tree Functions
bt_page_items, B-Tree Functions
bt_page_stats, B-Tree Functions
buffering storage parameter, Index Storage Parameters
bytea, 二进制数据类型

C

C, libpq — C Library, ECPG — Embedded SQL in C
CALL, CALL
canceling SQL queries, Canceling Queries in Progress
cardinality, Array Functions and Operators
CASCADE, 依赖关系跟踪
CASE, Conditional Expressions, UNION、CASE 及相关结构
确定结果类型, UNION、CASE 及相关结构
casefold, String Functions and Operators
cast, CREATE CAST
I/O conversion, CREATE CAST
cbrt, Mathematical Functions and Operators
ceil, Mathematical Functions and Operators
ceiling, Mathematical Functions and Operators
center, Geometric Functions and Operators
chained transactions, Transaction Management, Parameters, Parameters
in PL/pgSQL, Transaction Management
character string
concatenation, String Functions and Operators
converting to binary string, Binary String Functions and Operators
length, String Functions and Operators
prefix test, String Functions and Operators
character_length, String Functions and Operators
char_length, String Functions and Operators
CHECK OPTION, CREATE VIEW
CHECKPOINT, CHECKPOINT
chr, String Functions and Operators
circle, Geometric Functions and Operators
citext, citext — a case-insensitive character string type
client_encoding, 客户端与服务端编码自动转换
clock_timestamp, Date/Time Functions and Operators
CLOSE, CLOSE
CLUSTER, CLUSTER
clusterdb, clusterdb
COALESCE, COALESCE
COLLATE, 排序规则表达式
collation
in PL/pgSQL, Collation of PL/pgSQL Variables
COLLATION FOR, System Catalog Information Functions
color, Color Support
col_description, Comment Information Functions
comment
about database objects, Comment Information Functions
COMMENT, COMMENT
COMMIT, COMMIT
COMMIT PREPARED, COMMIT PREPARED
comparison, Comparison Functions and Operators, Subquery Expressions
composite type, Row and Array Comparisons
operators, Comparison Functions and Operators
row constructor, Row and Array Comparisons
subquery result row, Subquery Expressions
compiling, Building libpq Programs
libpq applications, Building libpq Programs
composite type
comparison, Row and Array Comparisons
concat, String Functions and Operators
concat_ws, String Functions and Operators
conditional expression, Conditional Expressions
configuration
of the server
functions, Configuration Settings Functions
conjunction, Logical Operators
connectby, Functions Provided, connectby
connection service file, The Connection Service File
conninfo, Connection Strings
CONTINUE
in PL/pgSQL, CONTINUE
convert, Binary String Functions and Operators
convert_from, Binary String Functions and Operators
convert_to, Binary String Functions and Operators
COPY, 向表中插入数据行, Functions Associated with the COPY Command, COPY
with libpq, Functions Associated with the COPY Command
corr, Aggregate Functions
correlation, Aggregate Functions
cos, Mathematical Functions and Operators
cosd, Mathematical Functions and Operators
cosh, Mathematical Functions and Operators
cot, Mathematical Functions and Operators
cotd, Mathematical Functions and Operators
count, Aggregate Functions
covariance
population, Aggregate Functions
sample, Aggregate Functions
covar_pop, Aggregate Functions
covar_samp, Aggregate Functions
crc32, Binary String Functions and Operators
crc32c, Binary String Functions and Operators
CREATE ACCESS METHOD, CREATE ACCESS METHOD
CREATE AGGREGATE, CREATE AGGREGATE
CREATE CAST, CREATE CAST
CREATE COLLATION, CREATE COLLATION
CREATE CONVERSION, CREATE CONVERSION
CREATE DATABASE, 创建数据库, CREATE DATABASE
CREATE DOMAIN, CREATE DOMAIN
CREATE EVENT TRIGGER, CREATE EVENT TRIGGER
CREATE EXTENSION, CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER, CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE, CREATE FOREIGN TABLE
CREATE FUNCTION, CREATE FUNCTION
CREATE GROUP, CREATE GROUP
CREATE INDEX, CREATE INDEX
CREATE LANGUAGE, CREATE LANGUAGE
CREATE MATERIALIZED VIEW, CREATE MATERIALIZED VIEW
CREATE OPERATOR, CREATE OPERATOR
CREATE OPERATOR CLASS, CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY, CREATE OPERATOR FAMILY
CREATE POLICY, CREATE POLICY
CREATE PROCEDURE, CREATE PROCEDURE
CREATE PUBLICATION, CREATE PUBLICATION
CREATE ROLE, 数据库角色, CREATE ROLE
CREATE RULE, CREATE RULE
CREATE SCHEMA, CREATE SCHEMA
CREATE SEQUENCE, CREATE SEQUENCE
CREATE SERVER, CREATE SERVER
CREATE STATISTICS, CREATE STATISTICS
CREATE SUBSCRIPTION, CREATE SUBSCRIPTION
CREATE 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 TRANSFORM, CREATE TRANSFORM
CREATE TRIGGER, CREATE TRIGGER
CREATE TYPE, CREATE TYPE
CREATE USER, CREATE USER
CREATE USER MAPPING, CREATE USER MAPPING
CREATE VIEW, CREATE VIEW
createdb, 创建数据库, createdb
createrole_self_grant configuration parameter
use in securing functions, Writing SECURITY DEFINER Functions Safely
createuser, 数据库角色, createuser
CREATE_REPLICATION_SLOT, Streaming Replication Protocol
crosstab, crosstab(text), crosstabN(text), crosstab(text, text)
crypt, crypt()
CSV (Comma-Separated Values) format
in psql, Meta-Commands
CTE, WITH 查询（公用表表达式）
CUBE, GROUPING SETS、CUBE 与 ROLLUP
cube (extension), cube — a multi-dimensional cube data type
cume_dist, Window Functions
hypothetical, Aggregate Functions
current_catalog, Session Information Functions
current_database, Session Information Functions
current_date, Date/Time Functions and Operators
current_logfiles
and the pg_current_logfile function, Session Information Functions
current_query, Session Information Functions
current_role, Session Information Functions
current_schema, Session Information Functions
current_schemas, Session Information Functions
current_setting, Configuration Settings Functions
current_time, Date/Time Functions and Operators
current_timestamp, Date/Time Functions and Operators
current_user, Session Information Functions
currval, Sequence Manipulation Functions
cursor, Cursors, CLOSE, DECLARE, EXPLAIN, FETCH, MOVE
CLOSE, CLOSE
DECLARE, DECLARE
FETCH, FETCH
in PL/pgSQL, Cursors
MOVE, MOVE
showing the query plan, EXPLAIN
custom scan provider, Writing a Custom Scan Provider
handler for, Writing a Custom Scan Provider

D

daitch_mokotoff, Daitch-Mokotoff Soundex
date
current, Current Date/Time
date_add, Date/Time Functions and Operators
date_bin, date_bin
date_part, Date/Time Functions and Operators, EXTRACT, date_part
date_subtract, Date/Time Functions and Operators
date_trunc, Date/Time Functions and Operators, date_trunc
dblink, dblink — connect to other PostgreSQL databases, dblink
dblink_build_sql_delete, dblink_build_sql_delete
dblink_build_sql_insert, dblink_build_sql_insert
dblink_build_sql_update, dblink_build_sql_update
dblink_cancel_query, dblink_cancel_query
dblink_close, dblink_close
dblink_connect, dblink_connect
dblink_connect_u, dblink_connect_u
dblink_disconnect, dblink_disconnect
dblink_error_message, dblink_error_message
dblink_exec, dblink_exec
dblink_fetch, dblink_fetch
dblink_get_connections, dblink_get_connections
dblink_get_notify, dblink_get_notify
dblink_get_pkey, dblink_get_pkey
dblink_get_result, dblink_get_result
dblink_is_busy, dblink_is_busy
dblink_open, dblink_open
dblink_send_query, dblink_send_query
DEALLOCATE, DEALLOCATE
dearmor, armor(), dearmor()
DECLARE, DECLARE
decode, Binary String Functions and Operators
decode_bytea
in PL/Perl, Utility Functions in PL/Perl
decrypt, Raw Encryption Functions
decrypt_iv, Raw Encryption Functions
deduplicate_items storage parameter, Index Storage Parameters
default-roles, Default Roles Renamed to Predefined Roles
deferrable transaction
setting, SET TRANSACTION
defined, hstore Operators and Functions
degrees, Mathematical Functions and Operators
delay, Delaying Execution
DELETE, 数据删除, 删除数据, 从修改的行中返回数据, DELETE
RETURNING, 从修改的行中返回数据
delete, hstore Operators and Functions
dense_rank, Window Functions
hypothetical, Aggregate Functions
diagonal, Geometric Functions and Operators
diameter, Geometric Functions and Operators
dict_int, dict_int — example full-text search dictionary for integers
dict_xsyn, dict_xsyn — example synonym full-text search dictionary
difference, Soundex
digest, digest()
DISCARD, DISCARD
disjunction, Logical Operators
DISTINCT, 查询数据表, DISTINCT 去重
div, Mathematical Functions and Operators
dmetaphone, Double Metaphone
dmetaphone_alt, Double Metaphone
DO, DO
DROP ACCESS METHOD, DROP ACCESS METHOD
DROP AGGREGATE, DROP AGGREGATE
DROP CAST, DROP CAST
DROP COLLATION, DROP COLLATION
DROP CONVERSION, DROP CONVERSION
DROP DATABASE, DROP DATABASE
DROP DOMAIN, DROP DOMAIN
DROP EVENT TRIGGER, DROP EVENT TRIGGER
DROP EXTENSION, DROP EXTENSION
DROP FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE, DROP FOREIGN TABLE
DROP FUNCTION, DROP FUNCTION
DROP GROUP, DROP GROUP
DROP INDEX, DROP INDEX
DROP LANGUAGE, DROP LANGUAGE
DROP MATERIALIZED VIEW, DROP MATERIALIZED VIEW
DROP OPERATOR, DROP OPERATOR
DROP OPERATOR CLASS, DROP OPERATOR CLASS
DROP OPERATOR FAMILY, DROP OPERATOR FAMILY
DROP OWNED, DROP OWNED
DROP POLICY, DROP POLICY
DROP PROCEDURE, DROP PROCEDURE
DROP PUBLICATION, DROP PUBLICATION
DROP ROLE, 数据库角色, DROP ROLE
DROP ROUTINE, DROP ROUTINE
DROP RULE, DROP RULE
DROP SCHEMA, DROP SCHEMA
DROP SEQUENCE, DROP SEQUENCE
DROP SERVER, DROP SERVER
DROP STATISTICS, DROP STATISTICS
DROP SUBSCRIPTION, DROP SUBSCRIPTION
DROP 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 TRANSFORM, DROP TRANSFORM
DROP TRIGGER, DROP TRIGGER
DROP TYPE, DROP TYPE
DROP USER, DROP USER
DROP USER MAPPING, DROP USER MAPPING
DROP VIEW, DROP VIEW
dropdb, dropdb
dropuser, 数据库角色, dropuser
DROP_REPLICATION_SLOT, Streaming Replication Protocol

E

each, hstore Operators and Functions
earth, Cube-Based Earth Distances
earthdistance, earthdistance — calculate great-circle distances
earth_box, Cube-Based Earth Distances
earth_distance, Cube-Based Earth Distances
ECPG, ECPG — Embedded SQL in C
ecpg, ecpg
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, ECPG — Embedded SQL in C
in C, ECPG — Embedded SQL in C
enabled role, enabled_roles
encode, Binary 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
encode_typed_literal
in PL/Perl, Utility Functions in PL/Perl
encrypt, Raw Encryption Functions
encryption, pgcrypto — cryptographic functions
for specific columns, pgcrypto — cryptographic functions
encrypt_iv, Raw Encryption Functions
END, END
enum_first, Enum Support Functions
enum_last, Enum Support Functions
enum_range, Enum Support Functions
environment variable, Environment Variables
ephemeral named relation
registering with SPI, SPI_register_relation, SPI_register_trigger_data
unregistering from SPI, SPI_unregister_relation
ereport, Reporting Errors Within the Server
erf, Mathematical Functions and Operators
erfc, Mathematical Functions and Operators
error codes, PostgreSQL Error Codes
libpq, Main Functions
list of, PostgreSQL Error Codes
error message
in PGcancelConn, Functions for Sending Cancel Requests
in PGconn, Connection Status Functions
escape format, Binary String Functions and Operators
escaping strings, Escaping Strings for Inclusion in SQL Commands
in libpq, Escaping Strings for Inclusion in SQL Commands
event trigger
in PL/Tcl, Event Trigger Functions in PL/Tcl
every, Aggregate Functions
EXCEPT, 组合查询
exceptions
in PL/pgSQL, Trapping Errors
in PL/Tcl, Error Handling in PL/Tcl
EXCLUDE, 排除约束
EXECUTE, EXECUTE
exist, hstore Operators and Functions
EXISTS, Subquery Expressions
EXIT
in PL/pgSQL, EXIT
exp, Mathematical Functions and Operators
EXPLAIN, 使用 EXPLAIN, EXPLAIN
EXPLAIN ANALYZE, EXPLAIN ANALYZE
extension
externally maintained, Extensions
extract, Date/Time Functions and Operators, EXTRACT, date_part

G

gamma, Mathematical Functions and Operators
gcd, Mathematical Functions and Operators
gc_to_sec, Cube-Based Earth Distances
generated column, Parameters, Parameters
generate_series, Set Returning Functions
generate_subscripts, Set Returning Functions
gen_random_bytes, Random-Data Functions
gen_random_uuid, UUID Functions, Random-Data Functions
gen_salt, gen_salt()
get_bit, Binary String Functions and Operators, Bit String Functions and Operators
get_byte, Binary String Functions and Operators
get_current_ts_config, Text Search Functions and Operators
get_raw_page, General Functions
gin_clean_pending_list, Index Maintenance Functions
gin_index_check, Functions
gin_leafpage_items, GIN Functions
gin_metapage_info, GIN Functions
gin_page_opaque_info, GIN Functions
gin_pending_list_limit
storage parameter, Index Storage Parameters
gist_page_items, GiST Functions
gist_page_items_bytea, GiST Functions
gist_page_opaque_info, GiST Functions
global data, Global Data in PL/Tcl
in PL/Python, Sharing Data
in PL/Tcl, Global Data in PL/Tcl
GRANT, 权限, GRANT
GREATEST, GREATEST and LEAST
Gregorian calendar, History of Units
GROUP BY, 聚合函数, GROUP BY 与 HAVING 子句
GROUPING, Aggregate Functions
GROUPING SETS, GROUPING SETS、CUBE 与 ROLLUP
GSSAPI
with libpq, Parameter Key Words

H

hash_bitmap_info, Hash Functions
hash_metapage_info, Hash Functions
hash_page_items, Hash Functions
hash_page_stats, Hash Functions
hash_page_type, Hash Functions
has_any_column_privilege, Access Privilege Inquiry Functions
has_column_privilege, Access Privilege Inquiry Functions
has_database_privilege, Access Privilege Inquiry Functions
has_foreign_data_wrapper_privilege, Access Privilege Inquiry Functions
has_function_privilege, Access Privilege Inquiry Functions
has_language_privilege, Access Privilege Inquiry Functions
has_largeobject_privilege, Access Privilege Inquiry Functions
has_parameter_privilege, Access Privilege Inquiry Functions
has_schema_privilege, Access Privilege Inquiry Functions
has_sequence_privilege, Access Privilege Inquiry Functions
has_server_privilege, Access Privilege Inquiry Functions
has_tablespace_privilege, Access Privilege Inquiry Functions
has_table_privilege, Access Privilege Inquiry Functions
has_type_privilege, Access Privilege Inquiry Functions
HAVING, 聚合函数, GROUP BY 与 HAVING 子句
heap_page_items, Heap Functions
heap_page_item_attrs, Heap Functions
heap_tuple_infomask_flags, Heap Functions
height, Geometric Functions and Operators
hex format, Binary String Functions and Operators
hmac, hmac()
host, Network Address Functions and Operators
host name, Parameter Key Words
hostmask, Network Address Functions and Operators
hstore, hstore — hstore key/value datatype, hstore Operators and Functions
hstore_to_array, hstore Operators and Functions
hstore_to_json, hstore Operators and Functions
hstore_to_jsonb, hstore Operators and Functions
hstore_to_jsonb_loose, hstore Operators and Functions
hstore_to_json_loose, hstore Operators and Functions
hstore_to_matrix, hstore Operators and Functions
hypothetical-set aggregate
built-in, Aggregate Functions

I

icount, intarray Functions and Operators
ICU, Parameters, Parameters
icu_unicode_version, Version Information Functions
IDENTIFY_SYSTEM, Streaming Replication Protocol
idx, intarray Functions and Operators
IFNULL, COALESCE
IMPORT FOREIGN SCHEMA, IMPORT FOREIGN SCHEMA
IN, Subquery Expressions, Row and Array Comparisons
INCLUDE, 仅索引扫描与覆盖索引
index, Building Indexes Concurrently, Rebuilding Indexes Concurrently, Operators and Functions
B-Tree, B-Tree Indexes
BRIN, BRIN Indexes
building concurrently, Building Indexes Concurrently
GIN, GIN Indexes
GiST, GiST Indexes
Hash, Hash Indexes
rebuilding concurrently, Rebuilding Indexes Concurrently
SP-GiST, SP-GiST Indexes
Index Access Method, Index Access Method Interface Definition
indexam
Index Access Method, Index Access Method Interface Definition
inet_client_addr, Session Information Functions
inet_client_port, Session Information Functions
inet_merge, Network Address Functions and Operators
inet_same_family, Network Address Functions and Operators
inet_server_addr, Session Information Functions
inet_server_port, Session Information Functions
information schema, The Information Schema
initcap, String Functions and Operators
initdb, initdb
Initialization Fork, The Initialization Fork
INSERT, 向表中插入数据行, 插入数据, 从修改的行中返回数据, INSERT
RETURNING, 从修改的行中返回数据
instr function, Appendix
intagg, intagg — integer aggregator and enumerator
intarray, intarray — manipulate arrays of integers
integer, 数值常量
interfaces
externally maintained, Client Interfaces
INTERSECT, 组合查询
intset, intarray Functions and Operators
int_array_aggregate, Functions
int_array_enum, Functions
inverse distribution, Aggregate Functions
in_range support functions, B-Tree Support Functions
IS DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
IS DOCUMENT, IS DOCUMENT
IS FALSE, Comparison Functions and Operators
IS JSON, Processing and Creating JSON Data
IS NOT DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
IS NOT DOCUMENT, IS NOT DOCUMENT
IS NOT FALSE, Comparison Functions and Operators
IS NOT NULL, Comparison Functions and Operators
IS NOT TRUE, Comparison Functions and Operators
IS NOT UNKNOWN, Comparison Functions and Operators
IS NULL, Comparison Functions and Operators
IS TRUE, Comparison Functions and Operators
IS UNKNOWN, Comparison Functions and Operators
isclosed, Geometric Functions and Operators
isempty, Range/Multirange Functions and Operators
isfinite, Date/Time Functions and Operators
isn, isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
isn.weak configuration parameter, Configuration Parameters
ISNULL, Comparison Functions and Operators
isn_weak, Functions and Operators
isopen, Geometric Functions and Operators
is_array_ref
in PL/Perl, Utility Functions in PL/Perl
is_valid, Functions and Operators

J

JIT, 即时编译（JIT）
JSON, JSON Functions and Operators
functions and operators, JSON Functions and Operators
json constructor, Processing and Creating JSON Data
jsonb_agg, Aggregate Functions
jsonb_agg_strict, Aggregate Functions
jsonb_array_elements, Processing and Creating JSON Data
jsonb_array_elements_text, Processing and Creating JSON Data
jsonb_array_length, Processing and Creating JSON Data
jsonb_build_array, Processing and Creating JSON Data
jsonb_build_object, Processing and Creating JSON Data
jsonb_each, Processing and Creating JSON Data
jsonb_each_text, Processing and Creating JSON Data
jsonb_extract_path, Processing and Creating JSON Data
jsonb_extract_path_text, Processing and Creating JSON Data
jsonb_insert, Processing and Creating JSON Data
jsonb_object, Processing and Creating JSON Data
jsonb_object_agg, Aggregate Functions
jsonb_object_agg_strict, Aggregate Functions
jsonb_object_agg_unique, Aggregate Functions
jsonb_object_agg_unique_strict, Aggregate Functions
jsonb_object_keys, Processing and Creating JSON Data
jsonb_path_exists, Processing and Creating JSON Data
jsonb_path_exists_tz, Processing and Creating JSON Data
jsonb_path_match, Processing and Creating JSON Data
jsonb_path_match_tz, Processing and Creating JSON Data
jsonb_path_query, Processing and Creating JSON Data
jsonb_path_query_array, Processing and Creating JSON Data
jsonb_path_query_array_tz, Processing and Creating JSON Data
jsonb_path_query_first, Processing and Creating JSON Data
jsonb_path_query_first_tz, Processing and Creating JSON Data
jsonb_path_query_tz, Processing and Creating JSON Data
jsonb_populate_record, Processing and Creating JSON Data
jsonb_populate_recordset, Processing and Creating JSON Data
jsonb_populate_record_valid, Processing and Creating JSON Data
jsonb_pretty, Processing and Creating JSON Data
jsonb_set, Processing and Creating JSON Data
jsonb_set_lax, Processing and Creating JSON Data
jsonb_strip_nulls, Processing and Creating JSON Data
jsonb_to_record, Processing and Creating JSON Data
jsonb_to_recordset, Processing and Creating JSON Data
jsonb_to_tsvector, Text Search Functions and Operators
jsonb_typeof, Processing and Creating JSON Data
json_agg, Aggregate Functions
json_agg_strict, Aggregate Functions
json_array, Processing and Creating JSON Data
json_arrayagg, Aggregate Functions
json_array_elements, Processing and Creating JSON Data
json_array_elements_text, Processing and Creating JSON Data
json_array_length, Processing and Creating JSON Data
json_build_array, Processing and Creating JSON Data
json_build_object, Processing and Creating JSON Data
json_each, Processing and Creating JSON Data
json_each_text, Processing and Creating JSON Data
json_exists, SQL/JSON Query Functions
json_extract_path, Processing and Creating JSON Data
json_extract_path_text, Processing and Creating JSON Data
json_object, Processing and Creating JSON Data
json_objectagg, Aggregate Functions
json_object_agg, Aggregate Functions
json_object_agg_strict, Aggregate Functions
json_object_agg_unique, Aggregate Functions
json_object_agg_unique_strict, Aggregate Functions
json_object_keys, Processing and Creating JSON Data
json_populate_record, Processing and Creating JSON Data
json_populate_recordset, Processing and Creating JSON Data
json_query, SQL/JSON Query Functions
json_scalar, Processing and Creating JSON Data
json_strip_nulls, Processing and Creating JSON Data
json_table, JSON_TABLE
json_to_record, Processing and Creating JSON Data
json_to_recordset, Processing and Creating JSON Data
json_to_tsvector, Text Search Functions and Operators
json_typeof, Processing and Creating JSON Data
json_value, SQL/JSON Query Functions
Julian date, Julian Dates
justify_days, Date/Time Functions and Operators
justify_hours, Date/Time Functions and Operators
justify_interval, Date/Time Functions and Operators

K

key word, SQL Key Words
list of, SQL Key Words

L

lag, Window Functions
lastval, Sequence Manipulation Functions
last_value, Window Functions
latitude, Cube-Based Earth Distances
lca, Operators and Functions
lcm, Mathematical Functions and Operators
LDAP connection parameter lookup, LDAP Lookup of Connection Parameters
lead, Window Functions
LEAST, GREATEST and LEAST
left, String Functions and Operators
length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators, Geometric Functions and Operators, Text Search Functions and Operators
of a binary string (see binary strings, length)
of a character string (see character string, length)
levenshtein, Levenshtein
levenshtein_less_equal, Levenshtein
lgamma, Mathematical Functions and Operators
libedit
in psql, Command-Line Editing
libpq, libpq — C Library, Pipeline Mode, Retrieving Query Results in Chunks, Retrieving Query Results in Chunks
chunked mode, Retrieving Query Results in Chunks
pipeline mode, Pipeline Mode
single-row mode, Retrieving Query Results in Chunks
libpq-fe.h, libpq — C Library, Connection Status Functions
libpq-int.h, Connection Status Functions
LIKE, LIKE
LIKE_REGEX, Differences from SQL Standard and XQuery, SQL/JSON Regular Expressions
in SQL/JSON, SQL/JSON Regular Expressions
LIMIT, LIMIT 与 OFFSET
line, Geometric Functions and Operators
linear regression, Aggregate Functions
LISTEN, LISTEN
ll_to_earth, Cube-Based Earth Distances
ln, Mathematical Functions and Operators
lo, lo — manage large objects
LOAD, LOAD
localtime, Date/Time Functions and Operators
localtimestamp, Date/Time Functions and Operators
LOCK, 表级锁, LOCK
log, Mathematical Functions and Operators
log10, Mathematical Functions and Operators
Logging
current_logfiles file and the pg_current_logfile function, Session Information Functions
pg_current_logfile function, Session Information Functions
log_autovacuum_min_duration
storage parameter, Storage Parameters
longitude, Cube-Based Earth Distances
looks_like_number
in PL/Perl, Utility Functions in PL/Perl
loop, Simple Loops
in PL/pgSQL, Simple Loops
lower, String Functions and Operators, Range/Multirange Functions and Operators
lower_inc, Range/Multirange Functions and Operators
lower_inf, Range/Multirange Functions and Operators
lpad, String Functions and Operators
lseg, Geometric Functions and Operators
LSN, WAL 内部机制
ltree, ltree — hierarchical tree-like data type
ltree2text, Operators and Functions
ltrim, String Functions and Operators, Binary String Functions and Operators

P

pageinspect, pageinspect — low-level inspection of database pages
pages_per_range storage parameter, Index Storage Parameters
page_checksum, General Functions
page_header, General Functions
parallel_workers storage parameter, Storage Parameters
parse_ident, String Functions and Operators
password file, The Password File
passwordcheck, passwordcheck — verify password strength
passwordcheck.min_password_length configuration parameter, Configuration Parameters
path, Geometric Functions and Operators
pattern matching, Pattern Matching
patterns
in psql and pg_dump, Patterns
pclose, Geometric Functions and Operators
percentile
continuous, Aggregate Functions
discrete, Aggregate Functions
percent_rank, Window Functions
hypothetical, Aggregate Functions
Perl, PL/Perl — Perl Procedural Language
PGAPPNAME, Environment Variables
pgbench, pgbench
PGcancel, Obsolete Functions for Sending Cancel Requests
PGcancelConn, Functions for Sending Cancel Requests
PGCHANNELBINDING, Environment Variables
PGCLIENTENCODING, Environment Variables
PGconn, Database Connection Control Functions
PGCONNECT_TIMEOUT, Environment Variables
pgcrypto, pgcrypto — cryptographic functions
pgcrypto.builtin_crypto_enabled configuration parameter, Configuration Parameters
PGDATABASE, Environment Variables
PGDATESTYLE, Environment Variables
PGEventProc, Event Callback Procedure
PGGEQO, Environment Variables
PGGSSDELEGATION, Environment Variables
PGGSSENCMODE, Environment Variables
PGGSSLIB, Environment Variables
PGHOST, Environment Variables
PGHOSTADDR, Environment Variables
PGKRBSRVNAME, Environment Variables
PGLOADBALANCEHOSTS, Environment Variables
PGLOCALEDIR, Environment Variables
PGMAXPROTOCOLVERSION, Environment Variables
PGMINPROTOCOLVERSION, Environment Variables
PGOPTIONS, Environment Variables
PGPASSFILE, Environment Variables
PGPASSWORD, Environment Variables
PGPORT, Environment Variables
pgp_armor_headers, pgp_armor_headers
pgp_key_id, pgp_key_id()
pgp_pub_decrypt, pgp_pub_decrypt()
pgp_pub_decrypt_bytea, pgp_pub_decrypt()
pgp_pub_encrypt, pgp_pub_encrypt()
pgp_pub_encrypt_bytea, pgp_pub_encrypt()
pgp_sym_decrypt, pgp_sym_decrypt()
pgp_sym_decrypt_bytea, pgp_sym_decrypt()
pgp_sym_encrypt, pgp_sym_encrypt()
pgp_sym_encrypt_bytea, pgp_sym_encrypt()
PGREQUIREAUTH, Environment Variables
PGREQUIREPEER, Environment Variables
PGREQUIRESSL, Environment Variables
PGresult, Main Functions
pgrowlocks, pgrowlocks — show a table's row locking information, Overview
PGSERVICE, Environment Variables
PGSERVICEFILE, Environment Variables
PGSSLCERT, Environment Variables
PGSSLCERTMODE, Environment Variables
PGSSLCOMPRESSION, Environment Variables
PGSSLCRL, Environment Variables
PGSSLCRLDIR, Environment Variables
PGSSLKEY, Environment Variables
PGSSLMAXPROTOCOLVERSION, Environment Variables
PGSSLMINPROTOCOLVERSION, Environment Variables
PGSSLMODE, Environment Variables
PGSSLNEGOTIATION, Environment Variables
PGSSLROOTCERT, Environment Variables
PGSSLSNI, Environment Variables
pgstatginindex, Functions
pgstathashindex, Functions
pgstatindex, Functions
pgstattuple, pgstattuple — obtain tuple-level statistics, Functions
pgstattuple_approx, Functions
PGSYSCONFDIR, Environment Variables
PGTARGETSESSIONATTRS, Environment Variables
PGTZ, Environment Variables
PGUSER, Environment Variables
PGXS, 扩展构建基础设施 PGXS
pg_advisory_lock, Advisory Lock Functions
pg_advisory_lock_shared, Advisory Lock Functions
pg_advisory_unlock, Advisory Lock Functions
pg_advisory_unlock_all, Advisory Lock Functions
pg_advisory_unlock_shared, Advisory Lock Functions
pg_advisory_xact_lock, Advisory Lock Functions
pg_advisory_xact_lock_shared, Advisory Lock Functions
pg_aggregate, pg_aggregate
pg_aios, pg_aios
pg_am, pg_am
pg_amcheck, pg_amcheck
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_available_extensions, pg_available_extensions
pg_available_extension_versions, pg_available_extension_versions
pg_available_wal_summaries, WAL Summarization Information Functions
pg_backend_memory_contexts, pg_backend_memory_contexts
pg_backend_pid, Session Information Functions
pg_backup_start, Backup Control Functions
pg_backup_stop, Backup Control Functions
pg_basebackup, pg_basebackup
pg_basetype, System Catalog Information Functions
pg_blocking_pids, Session Information Functions
pg_buffercache, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_evict, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_evict_all, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_evict_relation, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_numa, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_pages, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_summary, pg_buffercache — inspect PostgreSQL buffer cache state
pg_buffercache_usage_counts, pg_buffercache — inspect PostgreSQL buffer cache state
pg_cancel_backend, Server Signaling Functions
pg_cast, pg_cast
pg_char_to_encoding, System Catalog Information Functions
pg_checksums, pg_checksums
pg_class, pg_class
pg_clear_attribute_stats, Database Object Management Functions
pg_clear_relation_stats, Database Object Management Functions
pg_client_encoding, String Functions and Operators
pg_collation, pg_collation
pg_collation_actual_version, Database Object Management Functions
pg_collation_is_visible, Schema Visibility Inquiry Functions
PG_COLOR, When Color is Used
PG_COLORS, Configuring the Colors
pg_column_compression, Database Object Management Functions
pg_column_size, Database Object Management Functions
pg_column_toast_chunk_id, Database Object Management Functions
pg_combinebackup, pg_combinebackup
pg_config, pg_config, pg_config
with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs
pg_conf_load_time, Session Information Functions
pg_constraint, pg_constraint
pg_controldata, pg_controldata
pg_control_checkpoint, Control Data Functions
pg_control_init, Control Data Functions
pg_control_recovery, Control Data Functions
pg_control_system, Control Data Functions
pg_conversion, pg_conversion
pg_conversion_is_visible, Schema Visibility Inquiry Functions
pg_copy_logical_replication_slot, Replication Management Functions
pg_copy_physical_replication_slot, Replication Management Functions
pg_createsubscriber, pg_createsubscriber
pg_create_logical_replication_slot, Replication Management Functions
pg_create_physical_replication_slot, Replication Management Functions
pg_create_restore_point, Backup Control Functions
pg_ctl, pg_ctl
pg_current_logfile, Session Information Functions
pg_current_snapshot, Transaction ID and Snapshot Information Functions
pg_current_wal_flush_lsn, Backup Control Functions
pg_current_wal_insert_lsn, Backup Control Functions
pg_current_wal_lsn, Backup Control Functions
pg_current_xact_id, Transaction ID and Snapshot Information Functions
pg_current_xact_id_if_assigned, Transaction ID and Snapshot Information Functions
pg_cursors, pg_cursors
pg_database, pg_database
pg_database_collation_actual_version, Database Object Management Functions
pg_database_size, Database Object Management Functions
pg_db_role_setting, pg_db_role_setting
pg_default_acl, pg_default_acl
pg_depend, pg_depend
pg_describe_object, Object Information and Addressing Functions
pg_description, pg_description
pg_drop_replication_slot, Replication Management Functions
pg_dump, pg_dump
pg_dumpall, pg_dumpall
pg_encoding_to_char, System Catalog Information Functions
pg_enum, pg_enum
pg_event_trigger, pg_event_trigger
pg_event_trigger_ddl_commands, Capturing Changes at Command End
pg_event_trigger_dropped_objects, Processing Objects Dropped by a DDL Command
pg_event_trigger_table_rewrite_oid, Handling a Table Rewrite Event
pg_event_trigger_table_rewrite_reason, Handling a Table Rewrite Event
pg_export_snapshot, Snapshot Synchronization Functions
pg_extension, pg_extension
pg_filenode_relation, Database Object Management Functions
pg_file_settings, pg_file_settings
pg_foreign_data_wrapper, pg_foreign_data_wrapper
pg_foreign_server, pg_foreign_server
pg_foreign_table, pg_foreign_table
pg_freespace, Functions
pg_freespacemap, pg_freespacemap — examine the free space map
pg_function_is_visible, Schema Visibility Inquiry Functions
pg_get_acl, Object Information and Addressing Functions
pg_get_catalog_foreign_keys, System Catalog Information Functions
pg_get_constraintdef, System Catalog Information Functions
pg_get_expr, System Catalog Information Functions
pg_get_functiondef, System Catalog Information Functions
pg_get_function_arguments, System Catalog Information Functions
pg_get_function_identity_arguments, System Catalog Information Functions
pg_get_function_result, System Catalog Information Functions
pg_get_indexdef, System Catalog Information Functions
pg_get_keywords, System Catalog Information Functions
pg_get_loaded_modules, Session Information Functions
pg_get_multixact_members, Transaction ID and Snapshot Information Functions
pg_get_object_address, Object Information and Addressing Functions
pg_get_partition_constraintdef, System Catalog Information Functions
pg_get_partkeydef, System Catalog Information Functions
pg_get_ruledef, System Catalog Information Functions
pg_get_serial_sequence, System Catalog Information Functions
pg_get_statisticsobjdef, System Catalog Information Functions
pg_get_triggerdef, System Catalog Information Functions
pg_get_userbyid, System Catalog Information Functions
pg_get_viewdef, System Catalog Information Functions
pg_get_wal_replay_pause_state, Recovery Control Functions
pg_get_wal_resource_managers, Recovery Control Functions
pg_get_wal_summarizer_state, WAL Summarization Information Functions
pg_group, pg_group
pg_has_role, Access Privilege Inquiry Functions
pg_hba.conf, pg_hba.conf 配置文件
pg_hba_file_rules, pg_hba_file_rules
pg_identify_object, Object Information and Addressing Functions
pg_identify_object_as_address, Object Information and Addressing Functions
pg_ident_file_mappings, pg_ident_file_mappings
pg_import_system_collations, Database Object Management Functions
pg_index, pg_index
pg_indexam_has_property, System Catalog Information Functions
pg_indexes, pg_indexes
pg_indexes_size, Database Object Management Functions
pg_index_column_has_property, System Catalog Information Functions
pg_index_has_property, System Catalog Information Functions
pg_inherits, pg_inherits
pg_init_privs, pg_init_privs
pg_input_error_info, Data Validity Checking Functions
pg_input_is_valid, Data Validity Checking Functions
pg_isready, pg_isready
pg_is_in_recovery, Recovery Control Functions
pg_is_other_temp_schema, Session Information Functions
pg_is_wal_replay_paused, Recovery Control Functions
pg_jit_available, Session Information Functions
pg_language, pg_language
pg_largeobject, pg_largeobject
pg_largeobject_metadata, pg_largeobject_metadata
pg_last_committed_xact, Committed Transaction Information Functions
pg_last_wal_receive_lsn, Recovery Control Functions
pg_last_wal_replay_lsn, Recovery Control Functions
pg_last_xact_replay_timestamp, Recovery Control Functions
pg_listening_channels, Session Information Functions
pg_locks, pg_locks
pg_logicalinspect, pg_logicalinspect — logical decoding components inspection
pg_logical_emit_message, Replication Management Functions
pg_logical_slot_get_binary_changes, Replication Management Functions
pg_logical_slot_get_changes, Replication Management Functions
pg_logical_slot_peek_binary_changes, Replication Management Functions
pg_logical_slot_peek_changes, Replication Management Functions
pg_log_backend_memory_contexts, Server Signaling Functions
pg_log_standby_snapshot, Snapshot Synchronization Functions
pg_lsn, pg_lsn 类型
pg_ls_archive_statusdir, Generic File Access Functions
pg_ls_dir, Generic File Access Functions
pg_ls_logdir, Generic File Access Functions
pg_ls_logicalmapdir, Generic File Access Functions
pg_ls_logicalsnapdir, Generic File Access Functions
pg_ls_replslotdir, Generic File Access Functions
pg_ls_summariesdir, Generic File Access Functions
pg_ls_tmpdir, Generic File Access Functions
pg_ls_waldir, Generic File Access Functions
pg_matviews, pg_matviews
pg_mcv_list_items, Inspecting MCV Lists
pg_my_temp_schema, Session Information Functions
pg_namespace, pg_namespace
pg_notification_queue_usage, Session Information Functions
pg_notify, pg_notify
pg_numa_available, Session Information Functions
pg_opclass, pg_opclass
pg_opclass_is_visible, Schema Visibility Inquiry Functions
pg_operator, pg_operator
pg_operator_is_visible, Schema Visibility Inquiry Functions
pg_opfamily, pg_opfamily
pg_opfamily_is_visible, Schema Visibility Inquiry Functions
pg_options_to_table, System Catalog Information Functions
pg_overexplain, pg_overexplain — allow EXPLAIN to dump even more details
pg_parameter_acl, pg_parameter_acl
pg_partitioned_table, pg_partitioned_table
pg_partition_ancestors, Database Object Management Functions
pg_partition_root, Database Object Management Functions
pg_partition_tree, Database Object Management Functions
pg_policies, pg_policies
pg_policy, pg_policy
pg_postmaster_start_time, Session Information Functions
pg_prepared_statements, pg_prepared_statements
pg_prepared_xacts, pg_prepared_xacts
pg_prewarm, pg_prewarm — preload relation data into buffer caches
pg_prewarm.autoprewarm configuration parameter, Configuration Parameters
pg_prewarm.autoprewarm_interval configuration parameter, Configuration Parameters
pg_proc, pg_proc
pg_promote, Recovery Control Functions
pg_publication, pg_publication
pg_publication_namespace, pg_publication_namespace
pg_publication_rel, pg_publication_rel
pg_publication_tables, pg_publication_tables
pg_range, pg_range
pg_read_binary_file, Generic File Access Functions
pg_read_file, Generic File Access Functions
pg_receivewal, pg_receivewal
pg_receivexlog, pg_receivexlog renamed to pg_receivewal (see pg_receivewal)
pg_recvlogical, pg_recvlogical
pg_relation_filenode, Database Object Management Functions
pg_relation_filepath, Database Object Management Functions
pg_relation_size, Database Object Management Functions
pg_reload_conf, Server Signaling Functions
pg_relpages, Functions
pg_replication_origin, pg_replication_origin
pg_replication_origin_advance, Replication Management Functions
pg_replication_origin_create, Replication Management Functions
pg_replication_origin_drop, Replication Management Functions
pg_replication_origin_oid, Replication Management Functions
pg_replication_origin_progress, Replication Management Functions
pg_replication_origin_session_is_setup, Replication Management Functions
pg_replication_origin_session_progress, Replication Management Functions
pg_replication_origin_session_reset, Replication Management Functions
pg_replication_origin_session_setup, Replication Management Functions
pg_replication_origin_status, pg_replication_origin_status
pg_replication_origin_xact_reset, Replication Management Functions
pg_replication_origin_xact_setup, Replication Management Functions
pg_replication_slots, pg_replication_slots
pg_replication_slot_advance, Replication Management Functions
pg_resetwal, pg_resetwal
pg_resetxlog, pg_resetxlog renamed to pg_resetwal (see pg_resetwal)
pg_restore, pg_restore
pg_restore_attribute_stats, Database Object Management Functions
pg_restore_relation_stats, Database Object Management Functions
pg_rewind, pg_rewind
pg_rewrite, pg_rewrite
pg_roles, pg_roles
pg_rotate_logfile, Server Signaling Functions
pg_rules, pg_rules
pg_safe_snapshot_blocking_pids, Session Information Functions
pg_seclabel, pg_seclabel
pg_seclabels, pg_seclabels
pg_sequence, pg_sequence
pg_sequences, pg_sequences
pg_service.conf, The Connection Service File
pg_settings, pg_settings
pg_settings_get_flags, System Catalog Information Functions
pg_shadow, pg_shadow
pg_shdepend, pg_shdepend
pg_shdescription, pg_shdescription
pg_shmem_allocations, pg_shmem_allocations
pg_shmem_allocations_numa, pg_shmem_allocations_numa
pg_shseclabel, pg_shseclabel
pg_size_bytes, Database Object Management Functions
pg_size_pretty, Database Object Management Functions
pg_sleep, Delaying Execution
pg_sleep_for, Delaying Execution
pg_sleep_until, Delaying Execution
pg_snapshot_xip, Transaction ID and Snapshot Information Functions
pg_snapshot_xmax, Transaction ID and Snapshot Information Functions
pg_snapshot_xmin, Transaction ID and Snapshot Information Functions
pg_split_walfile_name, Backup Control Functions
pg_statistic, pg_statistic
pg_statistics_obj_is_visible, Schema Visibility Inquiry Functions
pg_statistic_ext, pg_statistic_ext
pg_statistic_ext_data, pg_statistic_ext
pg_stats, pg_stats
pg_stats_ext, pg_stats_ext
pg_stats_ext_exprs, pg_stats_ext_exprs
pg_stat_activity, 会话活动实时监控（pg_stat_activity）
pg_stat_file, Generic File Access Functions
pg_stat_statements, pg_stat_statements — track statistics of SQL planning and execution
function, Functions
pg_stat_statements.max configuration parameter, Configuration Parameters
pg_stat_statements.save configuration parameter, Configuration Parameters
pg_stat_statements.track configuration parameter, Configuration Parameters
pg_stat_statements.track_planning configuration parameter, Configuration Parameters
pg_stat_statements.track_utility configuration parameter, Configuration Parameters
pg_stat_statements_info, The pg_stat_statements_info View
pg_stat_statements_reset, Functions
pg_subscription, pg_subscription
pg_subscription_rel, pg_subscription_rel
pg_surgery, pg_surgery — perform low-level surgery on relation data
pg_switch_wal, Backup Control Functions
pg_sync_replication_slots, Replication Management Functions
pg_tables, pg_tables
pg_tablespace, pg_tablespace
pg_tablespace_databases, System Catalog Information Functions
pg_tablespace_location, System Catalog Information Functions
pg_tablespace_size, Database Object Management Functions
pg_table_is_visible, Schema Visibility Inquiry Functions
pg_table_size, Database Object Management Functions
pg_temp
securing functions, Writing SECURITY DEFINER Functions Safely
pg_terminate_backend, Server Signaling Functions
pg_test_fsync, pg_test_fsync
pg_test_timing, pg_test_timing
pg_timezone_abbrevs, pg_timezone_abbrevs
pg_timezone_names, pg_timezone_names
pg_total_relation_size, Database Object Management Functions
pg_transform, pg_transform
pg_trgm, pg_trgm — support for similarity of text using trigram matching
pg_trgm.similarity_threshold configuration parameter, GUC Parameters
pg_trgm.strict_word_similarity_threshold configuration parameter, GUC Parameters
pg_trgm.word_similarity_threshold configuration parameter, GUC Parameters
pg_trigger, pg_trigger
pg_trigger_depth, Session Information Functions
pg_try_advisory_lock, Advisory Lock Functions
pg_try_advisory_lock_shared, Advisory Lock Functions
pg_try_advisory_xact_lock, Advisory Lock Functions
pg_try_advisory_xact_lock_shared, Advisory Lock Functions
pg_ts_config, pg_ts_config
pg_ts_config_is_visible, Schema Visibility Inquiry Functions
pg_ts_config_map, pg_ts_config_map
pg_ts_dict, pg_ts_dict
pg_ts_dict_is_visible, Schema Visibility Inquiry Functions
pg_ts_parser, pg_ts_parser
pg_ts_parser_is_visible, Schema Visibility Inquiry Functions
pg_ts_template, pg_ts_template
pg_ts_template_is_visible, Schema Visibility Inquiry Functions
pg_type, pg_type
pg_typeof, System Catalog Information Functions
pg_type_is_visible, Schema Visibility Inquiry Functions
pg_upgrade, pg_upgrade
pg_user, pg_user
pg_user_mapping, pg_user_mapping
pg_user_mappings, pg_user_mappings
pg_verifybackup, pg_verifybackup
pg_views, pg_views
pg_visibility, pg_visibility — visibility map information and utilities
pg_visible_in_snapshot, Transaction ID and Snapshot Information Functions
pg_wait_events, pg_wait_events
pg_waldump, pg_waldump
pg_walfile_name, Backup Control Functions
pg_walfile_name_offset, Backup Control Functions
pg_walinspect, pg_walinspect — low-level WAL inspection
pg_walsummary, pg_walsummary
pg_wal_lsn_diff, Backup Control Functions
pg_wal_replay_pause, Recovery Control Functions
pg_wal_replay_resume, Recovery Control Functions
pg_wal_summary_contents, WAL Summarization Information Functions
pg_xact_commit_timestamp, Committed Transaction Information Functions
pg_xact_commit_timestamp_origin, Committed Transaction Information Functions
pg_xact_status, Transaction ID and Snapshot Information Functions
pg_xlogdump, pg_xlogdump renamed to pg_waldump (see pg_waldump)
phraseto_tsquery, Text Search Functions and Operators
pi, Mathematical Functions and Operators
PID
determining PID of server process
in libpq, Connection Status Functions
pipelining, Pipeline Mode, Pipelining
in libpq, Pipeline Mode
protocol specification, Pipelining
PITR, 备份与恢复
pkg-config
with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs
PL/Perl, PL/Perl — Perl Procedural Language
PL/PerlU, Trusted and Untrusted PL/Perl
PL/pgSQL, PL/pgSQL — SQL Procedural Language
PL/Python, PL/Python — Python Procedural Language
PL/SQL (Oracle), Porting from Oracle PL/SQL
porting to PL/pgSQL, Porting from Oracle PL/SQL
PL/Tcl, PL/Tcl — Tcl Procedural Language
plainto_tsquery, Text Search Functions and Operators
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.check_asserts configuration parameter, Checking Assertions
plpgsql.variable_conflict configuration parameter, Variable Substitution
pltcl.start_proc configuration parameter, PL/Tcl Configuration
pltclu.start_proc configuration parameter, PL/Tcl Configuration
point, Geometric Functions and Operators
polygon, Geometric Functions and Operators
popcount (see bit_count)
popen, Geometric Functions and Operators
populate_record, hstore Operators and Functions
port, Parameter Key Words
portal
DECLARE, DECLARE
in PL/pgSQL, Opening Cursors
position, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
POSITION_REGEX, Differences from SQL Standard and XQuery
POSTGRES, 伯克利 POSTGRES 项目
postgres, 体系架构基础, postgres
postgres 用户, PostgreSQL 用户账户
Postgres95, Postgres95
postgres_fdw, postgres_fdw — access data stored in external PostgreSQL servers
postgres_fdw.application_name configuration parameter, Configuration Parameters
power, Mathematical Functions and Operators
PQAUTHDATA_OAUTH_BEARER_TOKEN, Hook Types
PQAUTHDATA_PROMPT_OAUTH_DEVICE, Hook Types
PQbackendPID, Connection Status Functions
PQbinaryTuples, Retrieving Query Result Information
with COPY, Functions Associated with the COPY Command
PQcancel, Obsolete Functions for Sending Cancel Requests
PQcancelBlocking, Functions for Sending Cancel Requests
PQcancelCreate, Functions for Sending Cancel Requests
PQcancelErrorMessage, Functions for Sending Cancel Requests
PQcancelFinish, Functions for Sending Cancel Requests
PQcancelPoll, Functions for Sending Cancel Requests
PQcancelReset, Functions for Sending Cancel Requests
PQcancelSocket, Functions for Sending Cancel Requests
PQcancelStart, Functions for Sending Cancel Requests
PQcancelStatus, Functions for Sending Cancel Requests
PQchangePassword, Miscellaneous Functions
PQclear, Main Functions
PQclientEncoding, Control Functions
PQclosePortal, Main Functions
PQclosePrepared, Main 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
PQconnectionUsedGSSAPI, Connection Status Functions
PQconnectionUsedPassword, Connection Status Functions
PQconnectPoll, Database Connection Control Functions
PQconnectStart, Database Connection Control Functions
PQconnectStartParams, Database Connection Control Functions
PQconninfo, 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
PQencryptPasswordConn, Miscellaneous Functions
PQendcopy, Obsolete Functions for COPY
PQenterPipelineMode, Functions Associated with Pipeline Mode
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
PQexitPipelineMode, Functions Associated with Pipeline Mode
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, Obsolete Functions for Sending Cancel Requests
PQfreemem, Miscellaneous Functions
PQfsize, Retrieving Query Result Information
PQftable, Retrieving Query Result Information
PQftablecol, Retrieving Query Result Information
PQftype, Retrieving Query Result Information
PQfullProtocolVersion, Connection Status Functions
PQgetAuthDataHook, Authdata Hooks
PQgetCancel, Obsolete Functions for Sending Cancel Requests
PQgetCopyData, Functions for Receiving COPY Data
PQgetCurrentTimeUSec, Miscellaneous Functions
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
PQgetSSLKeyPassHook_OpenSSL, Database Connection Control Functions
PQgetvalue, Retrieving Query Result Information
PQhost, Connection Status Functions
PQhostaddr, 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
PQlibVersion, Miscellaneous Functions
(see also PQserverVersion)
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
PQping, Database Connection Control Functions
PQpingParams, Database Connection Control Functions
PQpipelineStatus, Functions Associated with Pipeline Mode
PQpipelineSync, Functions Associated with Pipeline Mode
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, Obsolete Functions for Sending Cancel Requests
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
PQresultMemorySize, Miscellaneous Functions
PQresultSetInstanceData, Event Support Functions
PQresultStatus, Main Functions
PQresultVerboseErrorMessage, Main Functions
PQsendClosePortal, Asynchronous Command Processing
PQsendClosePrepared, Asynchronous Command Processing
PQsendDescribePortal, Asynchronous Command Processing
PQsendDescribePrepared, Asynchronous Command Processing
PQsendFlushRequest, Functions Associated with Pipeline Mode
PQsendPipelineSync, Functions Associated with Pipeline Mode
PQsendPrepare, Asynchronous Command Processing
PQsendQuery, Asynchronous Command Processing
PQsendQueryParams, Asynchronous Command Processing
PQsendQueryPrepared, Asynchronous Command Processing
PQserverVersion, Connection Status Functions
PQsetAuthDataHook, Authdata Hooks
PQsetChunkedRowsMode, Retrieving Query Results in Chunks
PQsetClientEncoding, Control Functions
PQsetdb, Database Connection Control Functions
PQsetdbLogin, Database Connection Control Functions
PQsetErrorContextVisibility, Control Functions
PQsetErrorVerbosity, Control Functions
PQsetInstanceData, Event Support Functions
PQsetnonblocking, Asynchronous Command Processing
PQsetNoticeProcessor, Notice Processing
PQsetNoticeReceiver, Notice Processing
PQsetResultAttrs, Miscellaneous Functions
PQsetSingleRowMode, Retrieving Query Results in Chunks
PQsetSSLKeyPassHook_OpenSSL, Database Connection Control Functions
PQsetTraceFlags, Control Functions
PQsetvalue, Miscellaneous Functions
PQsocket, Connection Status Functions
PQsocketPoll, Database Connection Control Functions
PQsslAttribute, Connection Status Functions
PQsslAttributeNames, Connection Status Functions
PQsslInUse, Connection Status Functions
PQsslStruct, 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
PREPARE, PREPARE
PREPARE TRANSACTION, PREPARE TRANSACTION
prepared statements, DEALLOCATE, EXECUTE, EXPLAIN, PREPARE
creating, PREPARE
executing, EXECUTE
removing, DEALLOCATE
showing the query plan, EXPLAIN
preparing a query
in PL/pgSQL, Plan Caching
in PL/Python, Database Access Functions
in PL/Tcl, Database Access from PL/Tcl
PRIMARY KEY, 主键
privilege
querying, Access Privilege Inquiry Functions
procedural language, Writing a Procedural Language Handler
externally maintained, Procedural Languages
handler for, Writing a Procedural Language Handler
protocol, Frontend/Backend Protocol
frontend-backend, Frontend/Backend Protocol
ps, 标准 Unix 监控工具
监控活动, 标准 Unix 监控工具
psql, 访问数据库, psql
Python, PL/Python — Python Procedural Language

R

radians, Mathematical Functions and Operators
radius, Geometric Functions and Operators
RAISE
in PL/pgSQL, Reporting Errors and Messages
random, Mathematical Functions and Operators
random_normal, Mathematical Functions and Operators
range_agg, Aggregate Functions
range_intersect_agg, Aggregate Functions
range_merge, Range/Multirange Functions and Operators
rank, Window Functions
hypothetical, Aggregate Functions
read-only transaction
setting, SET TRANSACTION
Readline
in psql, Command-Line Editing
READ_REPLICATION_SLOT, Streaming Replication Protocol
REASSIGN OWNED, REASSIGN OWNED
recovery.conf, recovery.conf file merged into postgresql.conf
RECURSIVE, 递归查询, CREATE VIEW
in views, CREATE VIEW
REFERENCES, 外键
REFRESH MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW
regexp_count, String Functions and Operators, POSIX Regular Expressions
regexp_instr, String Functions and Operators, POSIX Regular Expressions
regexp_like, String Functions and Operators, POSIX Regular Expressions
regexp_match, String Functions and Operators, POSIX Regular Expressions
regexp_matches, String Functions and Operators, POSIX Regular Expressions
regexp_replace, String Functions and Operators, POSIX Regular Expressions
regexp_split_to_array, String Functions and Operators, POSIX Regular Expressions
regexp_split_to_table, String Functions and Operators, POSIX Regular Expressions
regexp_substr, String Functions and Operators, POSIX Regular Expressions
regression intercept, Aggregate Functions
regression slope, Aggregate Functions
regr_avgx, Aggregate Functions
regr_avgy, Aggregate Functions
regr_count, Aggregate Functions
regr_intercept, Aggregate Functions
regr_r2, Aggregate Functions
regr_slope, Aggregate Functions
regr_sxx, Aggregate Functions
regr_sxy, Aggregate Functions
regr_syy, Aggregate Functions
regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions
(see also pattern matching)
REINDEX, 例行重建索引, REINDEX
reindexdb, reindexdb
RELEASE SAVEPOINT, RELEASE SAVEPOINT
repeat, String Functions and Operators
replace, String Functions and Operators
reporting errors
in PL/pgSQL, Reporting Errors and Messages
RESET, RESET
RESTRICT, 依赖关系跟踪
RETURN NEXT
in PL/pgSQL, RETURN NEXT and RETURN QUERY
RETURN QUERY
in PL/pgSQL, RETURN NEXT and RETURN QUERY
RETURNING, 从修改的行中返回数据
RETURNING INTO, Executing a Command with a Single-Row Result
in PL/pgSQL, Executing a Command with a Single-Row Result
reverse, String Functions and Operators, Binary String Functions and Operators
REVOKE, 权限, REVOKE
right, String Functions and Operators
RLS, 行安全性策略
role
applicable, applicable_roles
enabled, enabled_roles
ROLLBACK, ROLLBACK
rollback
psql, Variables
ROLLBACK PREPARED, ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT
ROLLUP, GROUPING SETS、CUBE 与 ROLLUP
round, Mathematical Functions and Operators
ROW, 行构造器
row estimation, Row Estimation Examples
multivariate, Multivariate Statistics Examples
planner, Row Estimation Examples
row-wise comparison, Row and Array Comparisons
row_number, Window Functions
row_security_active, Access Privilege Inquiry Functions
row_to_json, Processing and Creating JSON Data
rpad, String Functions and Operators
rtrim, String Functions and Operators, Binary String Functions and Operators

S

SAVEPOINT, SAVEPOINT
savepoints, RELEASE SAVEPOINT, ROLLBACK TO SAVEPOINT, SAVEPOINT
defining, SAVEPOINT
releasing, RELEASE SAVEPOINT
rolling back, ROLLBACK TO SAVEPOINT
scale, Mathematical Functions and Operators
schema
current, Session Information Functions
search path
current, Session Information Functions
object visibility, Schema Visibility Inquiry Functions
search_path, 模式
search_path configuration parameter
use in securing functions, Writing SECURITY DEFINER Functions Safely
SECURITY LABEL, SECURITY LABEL
sec_to_gc, Cube-Based Earth Distances
seg, seg — a datatype for line segments or floating point intervals
SELECT, 查询数据表, 查询, SELECT 输出列, SELECT
确定结果类型, SELECT 输出列
SELECT INTO, Executing a Command with a Single-Row Result, SELECT INTO
in PL/pgSQL, Executing a Command with a Single-Row Result
sepgsql, sepgsql — SELinux-, label-based mandatory access control (MAC) security module
sepgsql.debug_audit configuration parameter, GUC Parameters
sepgsql.permissive configuration parameter, GUC Parameters
sequence, Sequence Manipulation Functions
Server Name Indication, Parameter Key Words
session_user, Session Information Functions
SET, Configuration Settings Functions, SET
SET CONSTRAINTS, SET CONSTRAINTS
set returning functions, Set Returning Functions
functions, Set Returning Functions
SET ROLE, SET ROLE
SET SESSION AUTHORIZATION, SET SESSION AUTHORIZATION
SET TRANSACTION, SET TRANSACTION
setseed, Mathematical Functions and Operators
setval, Sequence Manipulation Functions
setweight, Text Search Functions and Operators
setweight for specific lexeme(s), Text Search Functions and Operators
set_bit, Binary String Functions and Operators, Bit String Functions and Operators
set_byte, Binary String Functions and Operators
set_config, Configuration Settings Functions
set_limit, Functions and Operators
set_masklen, Network Address Functions and Operators
sha224, Binary String Functions and Operators
sha256, Binary String Functions and Operators
sha384, Binary String Functions and Operators
sha512, Binary String Functions and Operators
shobj_description, Comment Information Functions
SHOW, Configuration Settings Functions, SHOW, Streaming Replication Protocol
show_limit, Functions and Operators
show_trgm, Functions and Operators
SIGHUP, 通过配置文件交互
sign, Mathematical Functions and Operators
signal
backend processes, Server Signaling Functions
SIMILAR TO, SIMILAR TO Regular Expressions
similarity, Functions and Operators
sin, Mathematical Functions and Operators
sind, Mathematical Functions and Operators
single-user mode, Options for Single-User Mode
sinh, Mathematical Functions and Operators
skeys, hstore Operators and Functions
sleep, Delaying Execution
slice, hstore Operators and Functions
sliced bread (see TOAST)
slope, Geometric Functions and Operators
SOME, Aggregate Functions, Subquery Expressions, Row and Array Comparisons
sort, intarray Functions and Operators
sort_asc, intarray Functions and Operators
sort_desc, intarray Functions and Operators
soundex, Soundex
SPI, Server Programming Interface, spi — Server Programming Interface features/examples
examples, spi — Server Programming Interface features/examples
spi_commit
in PL/Perl, Database Access from PL/Perl
SPI_commit, SPI_commit
SPI_commit_and_chain, SPI_commit
SPI_connect, SPI_connect
SPI_connect_ext, SPI_connect
SPI_copytuple, SPI_copytuple
spi_cursor_close
in PL/Perl, Database Access from PL/Perl
SPI_cursor_close, SPI_cursor_close
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_cursor_parse_open, SPI_cursor_parse_open
SPI_exec, SPI_exec
SPI_execp, SPI_execp
SPI_execute, SPI_execute
SPI_execute_extended, SPI_execute_extended
SPI_execute_plan, SPI_execute_plan
SPI_execute_plan_extended, SPI_execute_plan_extended
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
in PL/Perl, Database Access from PL/Perl
SPI_freeplan, SPI_freeplan
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_keepplan, SPI_keepplan
SPI_modifytuple, SPI_modifytuple
SPI_palloc, SPI_palloc
SPI_pfree, SPI_pfree
spi_prepare
in PL/Perl, Database Access from PL/Perl
SPI_prepare, SPI_prepare
SPI_prepare_cursor, SPI_prepare_cursor
SPI_prepare_extended, SPI_prepare_extended
SPI_prepare_params, SPI_prepare_params
spi_query
in PL/Perl, Database Access from PL/Perl
spi_query_prepared
in PL/Perl, Database Access from PL/Perl
SPI_register_relation, SPI_register_relation
SPI_register_trigger_data, SPI_register_trigger_data
SPI_repalloc, SPI_repalloc
SPI_result_code_string, SPI_result_code_string
SPI_returntuple, SPI_returntuple
spi_rollback
in PL/Perl, Database Access from PL/Perl
SPI_rollback, SPI_rollback
SPI_rollback_and_chain, SPI_rollback
SPI_saveplan, SPI_saveplan
SPI_scroll_cursor_fetch, SPI_scroll_cursor_fetch
SPI_scroll_cursor_move, SPI_scroll_cursor_move
SPI_start_transaction, SPI_start_transaction
SPI_unregister_relation, SPI_unregister_relation
split_part, String Functions and Operators
SQL/CLI, SQL Conformance
SQL/Foundation, SQL Conformance
SQL/Framework, SQL Conformance
SQL/JRT, SQL Conformance
SQL/JSON, JSON Functions and Operators
functions and expressions, JSON Functions and Operators
SQL/JSON path language, The SQL/JSON Path Language
SQL/MDA, SQL Conformance
SQL/MED, SQL Conformance
SQL/OLB, SQL Conformance
SQL/PGQ, SQL Conformance
SQL/PSM, SQL Conformance
SQL/Schemata, SQL Conformance
SQL/XML, SQL Conformance
limits and conformance, XML Limits and Conformance to SQL/XML
sqrt, Mathematical Functions and Operators
SSI, 简介
SSL, 利用 SSL 进行安全 TCP/IP 连接, SSL Support
in libpq, Connection Status Functions
with libpq, Parameter Key Words
TLS, 利用 SSL 进行安全 TCP/IP 连接, SSL Support
sslinfo, sslinfo — obtain client SSL information
ssl_cipher, Functions Provided
ssl_client_cert_present, Functions Provided
ssl_client_dn, Functions Provided
ssl_client_dn_field, Functions Provided
ssl_client_serial, Functions Provided
ssl_extension_info, Functions Provided
ssl_issuer_dn, Functions Provided
ssl_issuer_field, Functions Provided
ssl_is_used, Functions Provided
ssl_version, Functions Provided
standard deviation, Aggregate Functions
population, Aggregate Functions
sample, Aggregate Functions
standby.signal
pg_basebackup --write-recovery-conf, Options
standby_mode (see standby.signal)
START TRANSACTION, START TRANSACTION
starts_with, String Functions and Operators
START_REPLICATION, Streaming Replication Protocol
statement_timestamp, Date/Time Functions and Operators
statistics, Aggregate Functions
stddev, Aggregate Functions
stddev_pop, Aggregate Functions
stddev_samp, Aggregate Functions
storage parameters, Storage Parameters
strict_word_similarity, Functions and Operators
string_agg, Aggregate Functions
string_to_array, String Functions and Operators
string_to_table, String Functions and Operators
strip, Text Search Functions and Operators
strpos, String Functions and Operators
subarray, intarray Functions and Operators
subltree, Operators and Functions
subpath, Operators and Functions
subquery, Subquery Expressions
substr, String Functions and Operators, Binary String Functions and Operators
substring, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators, SIMILAR TO Regular Expressions, POSIX Regular Expressions
SUBSTRING_REGEX, Differences from SQL Standard and XQuery
subtransactions
in PL/Tcl, Explicit Subtransactions in PL/Tcl
sum, Aggregate Functions
support functions
in_range, B-Tree Support Functions
suppress_redundant_updates_trigger, Trigger Functions
svals, hstore Operators and Functions
system_user, Session Information Functions

T

Table Access Method, Table Access Method Interface Definition
TABLE command, SELECT
table function, xmltable
XMLTABLE, xmltable
table sampling method, Writing a Table Sampling Method
tableam
Table Access Method, Table Access Method Interface Definition
tablefunc, tablefunc — functions that return tables (crosstab and others)
TABLESAMPLE method, Writing a Table Sampling Method
tan, Mathematical Functions and Operators
tand, Mathematical Functions and Operators
tanh, Mathematical Functions and Operators
TAP, TAP 测试套件
Tcl, PL/Tcl — Tcl Procedural Language
tcn, tcn — a trigger function to notify listeners of changes to table content
test_decoding, test_decoding — SQL-based test/example module for WAL logical decoding
text, Network Address Functions and Operators
text search, 文本搜索类型
functions and operators, 文本搜索类型
text2ltree, Operators and Functions
threads, Behavior in Threaded Programs
with libpq, Behavior in Threaded Programs
time
current, Current Date/Time
time zone, POSIX Time Zone Specifications
conversion, AT TIME ZONE and AT LOCAL
input abbreviations, Date/Time Configuration Files
POSIX-style specification, POSIX Time Zone Specifications
TIMELINE_HISTORY, Streaming Replication Protocol
timeofday, Date/Time Functions and Operators
TOAST, TOAST
per-column storage settings, Description, Parameters
per-type storage settings, Description
与大对象对比, 简介
toast_tuple_target storage parameter, Storage Parameters
to_ascii, String Functions and Operators
to_bin, String Functions and Operators
to_char, Data Type Formatting Functions
to_date, Data Type Formatting Functions
to_hex, String Functions and Operators
to_json, Processing and Creating JSON Data
to_jsonb, Processing and Creating JSON Data
to_number, Data Type Formatting Functions
to_oct, String Functions and Operators
to_regclass, System Catalog Information Functions
to_regcollation, System Catalog Information Functions
to_regnamespace, System Catalog Information Functions
to_regoper, System Catalog Information Functions
to_regoperator, System Catalog Information Functions
to_regproc, System Catalog Information Functions
to_regprocedure, System Catalog Information Functions
to_regrole, System Catalog Information Functions
to_regtype, System Catalog Information Functions
to_regtypemod, System Catalog Information Functions
to_timestamp, Data Type Formatting Functions, Date/Time Functions and Operators
to_tsquery, Text Search Functions and Operators
to_tsvector, Text Search Functions and Operators
transaction isolation level
setting, SET TRANSACTION
transaction_timestamp, Date/Time Functions and Operators
transition tables, CREATE TRIGGER
(see also ephemeral named relation)
implementation in PLs, SPI_register_trigger_data
translate, String Functions and Operators
TRANSLATE_REGEX, Differences from SQL Standard and XQuery
trigger, Trigger Functions, Trigger Functions
constraint trigger, Description
in PL/pgSQL, Trigger Functions
in PL/Python, Trigger Functions
in PL/Tcl, Trigger Functions in PL/Tcl
triggered_change_notification, tcn — a trigger function to notify listeners of changes to table content
trim, String Functions and Operators, Binary String Functions and Operators
trim_array, Array Functions and Operators
trim_scale, Mathematical Functions and Operators
trunc, Mathematical Functions and Operators, Network Address Functions and Operators
TRUNCATE, TRUNCATE
trusted, Trusted and Untrusted PL/Perl
PL/Perl, Trusted and Untrusted PL/Perl
tsm_system_rows, tsm_system_rows — the SYSTEM_ROWS sampling method for TABLESAMPLE
tsm_system_time, tsm_system_time — the SYSTEM_TIME sampling method for TABLESAMPLE
tsquery_phrase, Text Search Functions and Operators
tsvector_to_array, Text Search Functions and Operators
tsvector_update_trigger, Trigger Functions
tsvector_update_trigger_column, Trigger Functions
ts_debug, Text Search Functions and Operators
ts_delete, Text Search Functions and Operators
ts_filter, Text Search Functions and Operators
ts_headline, Text Search Functions and Operators
ts_lexize, Text Search Functions and Operators
ts_parse, Text Search Functions and Operators
ts_rank, Text Search Functions and Operators
ts_rank_cd, Text Search Functions and Operators
ts_rewrite, Text Search Functions and Operators
ts_stat, Text Search Functions and Operators
ts_token_type, Text Search Functions and Operators
tuple_data_split, Heap Functions
txid_current, Transaction ID and Snapshot Information Functions
txid_current_if_assigned, Transaction ID and Snapshot Information Functions
txid_current_snapshot, Transaction ID and Snapshot Information Functions
txid_snapshot_xip, Transaction ID and Snapshot Information Functions
txid_snapshot_xmax, Transaction ID and Snapshot Information Functions
txid_snapshot_xmin, Transaction ID and Snapshot Information Functions
txid_status, Transaction ID and Snapshot Information Functions
txid_visible_in_snapshot, Transaction ID and Snapshot Information Functions
typedef
in ECPG, Typedefs

U

UESCAPE, 标识符与关键字, Unicode 转义字符串常量
unaccent, unaccent — a text search dictionary which removes diacritics, Functions
Unicode normalization, String Functions and Operators
Unicode 转义, Unicode 转义字符串常量
字符串常量中的 Unicode 转义, Unicode 转义字符串常量
标识符中的 Unicode 转义, 标识符与关键字
unicode_assigned, String Functions and Operators
unicode_version, Version Information Functions
UNION, 组合查询, UNION、CASE 及相关结构
确定结果类型, UNION、CASE 及相关结构
uniq, intarray Functions and Operators
UNIQUE, 唯一约束
unistr, String Functions and Operators
Unix domain socket, Parameter Key Words
UNLISTEN, UNLISTEN
unnest, Array Functions and Operators
for multirange, Range/Multirange Functions and Operators
for tsvector, Text Search Functions and Operators
updatable views, Updatable Views
UPDATE, 数据更新, 更新数据, 从修改的行中返回数据, UPDATE
RETURNING, 从修改的行中返回数据
UPLOAD_MANIFEST, Streaming Replication Protocol
upper, String Functions and Operators, Range/Multirange Functions and Operators
upper_inc, Range/Multirange Functions and Operators
upper_inf, Range/Multirange Functions and Operators
UPSERT, INSERT
URI, Connection Strings
user, Session Information Functions
current, Session Information Functions
user_catalog_table storage parameter, Storage Parameters
UUID, UUID 类型, UUID Functions
generating, UUID Functions
uuid-ossp, uuid-ossp — a UUID generator
uuidv4, UUID Functions
uuidv7, UUID Functions
uuid_extract_timestamp, UUID Functions
uuid_extract_version, UUID Functions
uuid_generate_v1, uuid-ossp Functions
uuid_generate_v1mc, uuid-ossp Functions
uuid_generate_v3, uuid-ossp Functions

V

vacuum, 例行清理
VACUUM, VACUUM
vacuumdb, vacuumdb
vacuumlo, vacuumlo
vacuum_index_cleanup storage parameter, Storage Parameters
vacuum_max_eager_freeze_failure_rate
storage parameter, Storage Parameters
vacuum_truncate
storage parameter, Storage Parameters
VALUES, VALUES 列表, VALUES
variance, Aggregate Functions
population, Aggregate Functions
sample, Aggregate Functions
var_pop, Aggregate Functions
var_samp, Aggregate Functions
version, Version Information Functions
Visibility Map, Visibility Map
VM (see Visibility Map)

X

XML, XML 类型
XML export, Mapping Tables to XML
XML Functions, XML Functions
xml2, xml2 — XPath querying and XSLT functionality
xmlagg, xmlagg, Aggregate Functions
xmlcomment, xmlcomment
xmlconcat, xmlconcat
xmlelement, xmlelement
XMLEXISTS, XMLEXISTS
xmlforest, xmlforest
xmlpi, xmlpi
xmlroot, xmlroot
xmltable, xmltable
xmltext, xmltext
xml_is_well_formed, xml_is_well_formed
xml_is_well_formed_content, xml_is_well_formed
xml_is_well_formed_document, xml_is_well_formed
XPath, xpath
xpath_exists, xpath_exists
xpath_table, xpath_table
XQuery regular expressions, Differences from SQL Standard and XQuery
xslt_process, xslt_process
上一页 上一级 
Bibliography 首页