PostgreSQL 文档检索
PG 18 · 按类别浏览,或输入名称与关键词
分类索引247
CREATE TABLE定义一个新表
define a new table
CREATE [ persistence_mode ] TABLE [ IF NOT EXISTS ] table_name ( [
{ column_name data_type [ column_storage ] [ column_compression ] [ COLLATE collation ] [ column_…SQL 命令 · 表与视图
EXPLAIN显示一个语句的执行计划
show the execution plan of a statement
EXPLAIN [ ( option [, ...] ) ] statement
where option can be one of:
ANALYZE [ boolean ]
VERBOSE [ boolean ]
COSTS [ boolean ]
SETTINGS [ …SQL 命令 · 查询与数据操作
SELECT空 SELECT 列表 SELECT 之后的输出表达式列表可以为空,这会产生一个零列的结果表。按照 SQL 标准,这不是合法的语法。PostgreSQL 允许这样做,是为了与允许零列的表保持一致。不过在使用 DISTINCT 时不允许空列表。SELECT › 兼容性 › 空 SELECT 列表
SELECT从表或视图中检索行
retrieve rows from a table or view
[ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
[ { * | expression [ [ AS ] output_name ] } [, …SQL 命令 · 查询与数据操作
ABORT中止当前事务
abort the current transaction
ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
事务控制SQL 命令 · 事务控制
ALL9.25.4. ALL(数组)# expression operator ALL (array expression) 右侧是一个用括号括起来的表达式,它必须产生一个数组值。左侧表达式会被求值,并使用给定的 operator 与数组的每个元素进行比较,该操作符必须产生布尔结果。如果所有比较都得到真值结果,那么 ALL 的结果是“真”(包括数组有零个元素的情况)。如果有任何假值结…行和数组比较 › ALL(数组)
ALTER AGGREGATE更改一个聚合函数的定义
change the definition of an aggregate function
ALTER AGGREGATE name ( aggregate_signature ) RENAME TO new_name
ALTER AGGREGATE name ( aggregate_signature )
OWNER TO { new_owner |…SQL 命令 · 函数与过程
ALTER COLLATION更改排序规则的定义
change the definition of a collation
ALTER COLLATION name REFRESH VERSION
ALTER COLLATION name RENAME TO new_name
ALTER COLLATION name OWNER TO { new_owner | CURRENT_ROLE | CURREN…SQL 命令 · 类型与运算符
ALTER CONVERSION更改一个转换的定义
change the definition of a conversion
ALTER CONVERSION name RENAME TO new_name
ALTER CONVERSION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER CONVE…SQL 命令 · 类型与运算符
ALTER DATABASE更改一个数据库
change a database
ALTER DATABASE name [ [ WITH ] option [ ... ] ]
where option can be:
ALLOW_CONNECTIONS allowconn
CONNECTION LIMIT connlimit
IS_TEMPLATE istemplate
ALTER DATABASE…SQL 命令 · 数据库、模式与表空间
ALTER DEFAULT PRIVILEGES定义默认访问权限
define default access privileges
ALTER DEFAULT PRIVILEGES
[ FOR { ROLE | USER } target_role [, ...] ]
[ IN SCHEMA schema_name [, ...] ]
abbreviated_grant_or_revoke
where abbreviated…SQL 命令 · 角色与权限
ALTER DOMAIN更改一个域的定义
change the definition of a domain
ALTER DOMAIN name
{ SET DEFAULT expression | DROP DEFAULT }
ALTER DOMAIN name
{ SET | DROP } NOT NULL
ALTER DOMAIN name
ADD domain_constraint [ NOT…SQL 命令 · 类型与运算符
ALTER EVENT TRIGGER更改事件触发器的定义
change the definition of an event trigger
ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CUR…SQL 命令 · 触发器与规则
ALTER EXTENSION更改扩展的定义
change the definition of an extension
ALTER EXTENSION name UPDATE [ TO new_version ]
ALTER EXTENSION name SET SCHEMA new_schema
ALTER EXTENSION name ADD member_object
ALTER EXTENSION…SQL 命令 · 扩展与访问方法
ALTER FOREIGN DATA WRAPPER更改外部数据包装器的定义
change the definition of a foreign-data wrapper
ALTER FOREIGN DATA WRAPPER name
[ HANDLER handler_function | NO HANDLER ]
[ VALIDATOR validator_function | NO VALIDATOR ]
[ CONNE…SQL 命令 · 外部数据
ALTER FOREIGN TABLE更改外部表的定义
change the definition of a foreign table
ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
action [, ... ]
ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
RENAME [ COLUMN …SQL 命令 · 外部数据
ALTER FUNCTION更改函数的定义
change the definition of a function
ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
action [ ... ] [ RESTRICT ]
ALTER FUNCTION name [ ( [ [ argmode ] [ argnam…SQL 命令 · 函数与过程
ALTER GROUP更改角色名称或成员资格
change role name or membership
ALTER GROUP role_specification ADD USER user_name [, ... ]
ALTER GROUP role_specification DROP USER user_name [, ... ]
where role_specification ca…SQL 命令 · 角色与权限
ALTER INDEX更改索引的定义
change the definition of an index
ALTER INDEX [ IF EXISTS ] name RENAME TO new_name
ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name
ALTER INDEX name ATTACH PARTITION in…SQL 命令 · 索引与统计
ALTER LANGUAGE更改一种过程语言的定义
change the definition of a procedural language
ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name
ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURR…SQL 命令 · 函数与过程
ALTER LARGE OBJECT更改一个大对象的定义
change the definition of a large object
ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
其它对象SQL 命令 · 其它对象
ALTER MATERIALIZED VIEW更改一个物化视图的定义
change the definition of a materialized view
ALTER MATERIALIZED VIEW [ IF EXISTS ] name
action [, ... ]
ALTER MATERIALIZED VIEW name
[ NO ] DEPENDS ON EXTENSION extension_name
AL…SQL 命令 · 表与视图
ALTER OPERATOR更改一个操作符的定义
change the definition of an operator
ALTER OPERATOR name ( { left_type | NONE } , right_type )
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER OPERATOR …SQL 命令 · 类型与运算符
ALTER OPERATOR CLASS更改一个操作符类的定义
change the definition of an operator class
ALTER OPERATOR CLASS name USING index_method
RENAME TO new_name
ALTER OPERATOR CLASS name USING index_method
OWNER TO { new_owner | CU…SQL 命令 · 类型与运算符
ALTER OPERATOR FAMILY更改一个操作符族的定义
change the definition of an operator family
ALTER OPERATOR FAMILY name USING index_method ADD
{ OPERATOR strategy_number operator_name ( op_type, op_type )
[ FOR SEARCH | FOR ORD…SQL 命令 · 类型与运算符
ALTER POLICY更改一条行级安全策略的定义
change the definition of a row-level security policy
ALTER POLICY name ON table_name RENAME TO new_name
ALTER POLICY name ON table_name
[ TO { role_name | PUBLIC | CURRENT_ROL…SQL 命令 · 角色与权限
ALTER PROCEDURE更改过程的定义
change the definition of a procedure
ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
action [ ... ] [ RESTRICT ]
ALTER PROCEDURE name [ ( [ [ argmode ] [ arg…SQL 命令 · 函数与过程
ALTER PUBLICATION修改发布的定义
change the definition of a publication
ALTER PUBLICATION name ADD publication_object [, ...]
ALTER PUBLICATION name DROP publication_drop_object [, ...]
ALTER PUBLICATION name SET { …SQL 命令 · 逻辑复制
ALTER ROLE更改数据库角色
change a database role
ALTER ROLE role_specification [ WITH ] option [ ... ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| INHE…SQL 命令 · 角色与权限
ALTER ROUTINE更改一个例程的定义
change the definition of a routine
ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
action [ ... ] [ RESTRICT ]
ALTER ROUTINE name [ ( [ [ argmode ] [ argname…SQL 命令 · 函数与过程
ALTER RULE修改一条重写规则的定义
change the definition of a rule
ALTER RULE name ON table_name RENAME TO new_name
触发器与规则SQL 命令 · 触发器与规则
ALTER SCHEMA更改一个模式的定义
change the definition of a schema
ALTER SCHEMA name RENAME TO new_name
ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
数据库、模式与表空间SQL 命令 · 数据库、模式与表空间
ALTER SEQUENCE更改序列发生器的定义
change the definition of a sequence generator
ALTER SEQUENCE [ IF EXISTS ] name
[ AS data_type ]
[ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxv…SQL 命令 · 表与视图
ALTER SERVER更改外部服务器的定义
change the definition of a foreign server
ALTER SERVER name [ VERSION 'new_version' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER name OWNER TO { n…SQL 命令 · 外部数据
ALTER STATISTICS更改扩展统计对象的定义
change the definition of an extended statistics object
ALTER STATISTICS name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER STATISTICS name RENAME TO n…SQL 命令 · 索引与统计
ALTER SUBSCRIPTION修改订阅的定义
change the definition of a subscription
ALTER SUBSCRIPTION name SERVER server_name
ALTER SUBSCRIPTION name CONNECTION 'conninfo'
ALTER SUBSCRIPTION name SET PUBLICATION publication_n…SQL 命令 · 逻辑复制
ALTER SYSTEM更改服务器配置参数
change a server configuration parameter
ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT }
ALTER SYSTEM RESET configuration_parameter
ALTER SYSTEM RES…SQL 命令 · 会话与参数
ALTER TABLE更改一个表的定义
change the definition of a table
ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
action [, ... ]
ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
RENAME [ COLUMN ] column_name TO new_col…SQL 命令 · 表与视图
ALTER TABLESPACE更改一个表空间的定义
change the definition of a tablespace
ALTER TABLESPACE name RENAME TO new_name
ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER TABL…SQL 命令 · 数据库、模式与表空间
ALTER TEXT SEARCH CONFIGURATION更改一个文本检索配置的定义
change the definition of a text search configuration
ALTER TEXT SEARCH CONFIGURATION name
ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
ALTER TEXT SEARCH CO…SQL 命令 · 全文检索
更多结果
输入名称或关键词,从 PostgreSQL 手册与扩展目录中直接找到定义。
pg17: 限定版本 ex: 只搜扩展 ↑↓ 选择 ↵ 打开