PostgreSQL 文档检索
PG 18 · 按类别浏览,或输入名称与关键词
分类索引247
CREATE INDEX定义一个新索引
define a new index
CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ]
( { column_name | ( expression ) } [ COLLATE collation …SQL 命令 · 索引与统计
CREATE LANGUAGE定义一种新的过程语言
define a new procedural language
CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name
HANDLER call_handler [ INLINE inline_handler ] [ VALIDATOR valfunction ]
CREATE [ O…SQL 命令 · 函数与过程
CREATE MATERIALIZED VIEW定义一个新物化视图
define a new materialized view
CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name
[ (column_name [, ...] ) ]
[ USING method ]
[ WITH ( storage_parameter [= value] [, ... ] ) ]
[…SQL 命令 · 表与视图
CREATE OPERATOR定义一个新的操作符
define a new operator
CREATE OPERATOR name (
{FUNCTION|PROCEDURE} = function_name
[, LEFTARG = left_type ] , RIGHTARG = right_type
[, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
[,…SQL 命令 · 类型与运算符
CREATE OPERATOR CLASS定义一个新的操作符类
define a new operator class
CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type
USING index_method [ FAMILY family_name ] AS
{ OPERATOR strategy_number operator_name [ ( op_…SQL 命令 · 类型与运算符
CREATE OPERATOR FAMILY定义一个新的操作符族
define a new operator family
CREATE OPERATOR FAMILY name USING index_method
类型与运算符SQL 命令 · 类型与运算符
CREATE POLICY为一个表定义一条新的行级安全策略
define a new row-level security policy for a table
CREATE POLICY name ON table_name
[ AS { PERMISSIVE | RESTRICTIVE } ]
[ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ]
[…SQL 命令 · 角色与权限
CREATE PROCEDURE定义一个新过程
define a new procedure
CREATE [ OR REPLACE ] PROCEDURE
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] )
{ LANGUAGE lang_name
| TRANSFORM { FOR TY…SQL 命令 · 函数与过程
CREATE PUBLICATION定义一个新的发布
define a new publication
CREATE PUBLICATION name
[ FOR { publication_object [, ... ] | publication_all_object [, ... ] } ]
[ WITH ( publication_parameter [= value] [, ... ] ) ]
whe…SQL 命令 · 逻辑复制
CREATE ROLE定义一个新的数据库角色
define a new database role
CREATE ROLE name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| INHER…SQL 命令 · 角色与权限
CREATE RULE定义一条新的重写规则
define a new rewrite rule
CREATE [ OR REPLACE ] RULE name AS ON event
TO table_name [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }
wh…SQL 命令 · 触发器与规则
CREATE SCHEMA定义一个新模式
define a new schema
CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ]
CREATE SCHEMA AUTHORIZATION role_specification [ schema_element [ ... ] …SQL 命令 · 数据库、模式与表空间
CREATE SEQUENCE定义一个新的序列发生器
define a new sequence generator
CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] name
[ AS data_type ]
[ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | N…SQL 命令 · 表与视图
CREATE SERVER定义一个新的外部服务器
define a new foreign server
CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]
FOREIGN DATA WRAPPER fdw_name
[ OPTIONS ( option 'valu…SQL 命令 · 外部数据
CREATE STATISTICS定义扩展统计信息
define extended statistics
CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ]
ON { column_name | ( expression ) }
FROM table_name
CREATE STATISTICS [ [ IF NOT EXISTS ] statist…SQL 命令 · 索引与统计
CREATE SUBSCRIPTION定义一个新的订阅
define a new subscription
CREATE SUBSCRIPTION subscription_name
{ SERVER server_name | CONNECTION 'conninfo' }
PUBLICATION publication_name [, ...]
[ WITH ( subscription_parameter […SQL 命令 · 逻辑复制
CREATE TABLE AS根据查询结果定义一个新表
define a new table from the results of a query
CREATE [ persistence_mode ] TABLE [ IF NOT EXISTS ] table_name
[ ( column_name [, ...] ) ]
[ USING method ]
[ WITH ( storage_param…SQL 命令 · 表与视图
CREATE TABLESPACE定义一个新表空间
define a new tablespace
CREATE TABLESPACE tablespace_name
[ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ]
LOCATION 'directory'
[ WITH ( tablespace_option = valu…SQL 命令 · 数据库、模式与表空间
CREATE TEXT SEARCH CONFIGURATION定义一个新的文本检索配置
define a new text search configuration
CREATE TEXT SEARCH CONFIGURATION name (
PARSER = parser_name |
COPY = source_config
)
全文检索SQL 命令 · 全文检索
CREATE TEXT SEARCH DICTIONARY定义一个新的文本检索词典
define a new text search dictionary
CREATE TEXT SEARCH DICTIONARY name (
TEMPLATE = template
[, option = value [, ... ]]
)
全文检索SQL 命令 · 全文检索
CREATE TEXT SEARCH PARSER定义一个新的文本检索解析器
define a new text search parser
CREATE TEXT SEARCH PARSER name (
START = start_function ,
GETTOKEN = gettoken_function ,
END = end_function ,
LEXTYPES = lextypes_function
[, HE…SQL 命令 · 全文检索
CREATE TEXT SEARCH TEMPLATE定义一个新的文本检索模板
define a new text search template
CREATE TEXT SEARCH TEMPLATE name (
[ INIT = init_function , ]
LEXIZE = lexize_function
)
全文检索SQL 命令 · 全文检索
CREATE TRANSFORM定义一个新的转换
define a new transform
CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name (
FROM SQL WITH FUNCTION from_sql_function_name [ (argument_type [, ...]) ],
TO SQL WITH FUNC…SQL 命令 · 函数与过程
CREATE TRIGGER定义一个新触发器
define a new trigger
CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
ON table_name
[ FROM referenced_table_name ]
[ NOT DEFERR…SQL 命令 · 触发器与规则
CREATE TYPE定义一种新数据类型
define a new data type
CREATE TYPE name AS
( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] )
CREATE TYPE name AS ENUM
( [ 'label' [, ... ] ] )
CREATE TYPE name AS R…SQL 命令 · 类型与运算符
CREATE USER定义一个新的数据库角色
define a new database role
CREATE USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| INHER…SQL 命令 · 角色与权限
CREATE USER MAPPING定义用户到外部服务器的新映射
define a new mapping of a user to a foreign server
CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }
SERVER server_name
[ O…SQL 命令 · 外部数据
CREATE VIEW定义一个新视图
define a new view
CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ]
[ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
AS query…SQL 命令 · 表与视图
CUBE7.2.4. GROUPING SETS、CUBE 和 ROLLUP # 使用分组集的概念可以实现比上述更加复杂的分组操作。由 FROM 和 WHERE 子句选出的数据被按照每一个指定的分组集单独分组,按照简单 GROUP BY 子句对每一个分组计算聚合,然后返回结果。例如: => SELECT * FROM items_sold; brand | size | sales -…表表达式 › GROUPING SETS、CUBE 和 ROLLUP
current_datecurrent_date → date 当前日期;参见第 9.9.5 节 current_date → 2019-12-23日期/时间函数和操作符
current_rolecurrent_role → name 这个等同于 current_user。系统信息函数和操作符 › 会话信息函数
current_timecurrent_time → time with time zone 一天中的当前时刻;参见第 9.9.5 节 current_time → 14:39:53.662522-05日期/时间函数和操作符
current_timestampcurrent_timestamp → timestamp with time zone 当前日期和时间(当前事务开始时);参见第 9.9.5 节 current_timestamp → 2019-12-23 14:39:53.662522-05日期/时间函数和操作符
current_usercurrent_user → name 返回当前执行上下文的用户名。系统信息函数和操作符 › 会话信息函数
DEALLOCATE释放一个预备语句
deallocate a prepared statement
DEALLOCATE [ PREPARE ] { name | ALL }
游标与预备语句SQL 命令 · 游标与预备语句
DECLARE定义一个游标
define a cursor
DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ]
CURSOR [ { WITH | WITHOUT } HOLD ] FOR query
游标与预备语句SQL 命令 · 游标与预备语句
DELETE删除表中的行
delete rows of a table
[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
[ USING from_item [, ...] ]
[ WHERE condition | WHERE CURRENT O…SQL 命令 · 查询与数据操作
DISCARD丢弃会话状态
discard session state
DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }
会话与参数SQL 命令 · 会话与参数
DISTINCT7.3.3. DISTINCT # 在处理完选择列表之后,结果表还可以选择性地删除重复行。我们可以直接在 SELECT 后面写上 DISTINCT 关键字来指定: SELECT DISTINCT select_list ... (如果不用 DISTINCT,则可以用 ALL 关键字来显式指定保留所有行这一默认行为。) 显然,如果两行至少在一个列值上不同,就认为它们是不同的。空值…选择列表 › DISTINCT
DO执行匿名代码块
execute an anonymous code block
DO [ LANGUAGE lang_name ] code
函数与过程SQL 命令 · 函数与过程
更多结果
输入名称或关键词,从 PostgreSQL 手册与扩展目录中直接找到定义。
pg17: 限定版本 ex: 只搜扩展 ↑↓ 选择 ↵ 打开