PostgreSQL 文档检索

CREATE RULESQL 命令与语法本站词条定义一条新的重写规则 CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } 其中 event 可以是以下之一： SELECT |…SQL 命令 · 触发器与规则 CREATE RULE章节正文PG18CREATE RULE CREATE RULE — 定义一条新的重写规则大纲 CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } 其…CREATE RULE CREATE SCHEMASQL 命令与语法本站词条定义一个新模式 CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION role_specification [ schema_element [ ... ] ] CREATE SCHEMA IF …SQL 命令 · 数据库、模式与表空间 CREATE SCHEMA章节正文PG18CREATE SCHEMA CREATE SCHEMA — 定义一个新模式大纲 CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION role_specification [ schema_elem…CREATE SCHEMA CREATE SEQUENCESQL 命令与语法本站词条定义一个新的序列发生器 CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalu…SQL 命令 · 表与视图 CREATE SEQUENCE章节正文PG18CREATE SEQUENCE CREATE SEQUENCE — 定义一个新的序列发生器大纲 CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue…CREATE SEQUENCE CREATE SERVERSQL 命令与语法本站词条定义一个新的外部服务器 CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ] FOREIGN DATA WRAPPER fdw_name [ OPTIONS ( option 'value' [, ... ] ) ] 外部数据SQL 命令 · 外部数据 CREATE SERVER章节正文PG18CREATE SERVER CREATE SERVER — 定义一个新的外部服务器大纲 CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ] FOREIGN DATA WRAPPER fdw_name [ OPTIONS ( option '…CREATE SERVER CREATE STATISTICSSQL 命令与语法本站词条定义扩展统计信息 CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON { column_name | ( expression ) } FROM table_name CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] [ ( statistics_…SQL 命令 · 索引与统计 CREATE STATISTICS章节正文PG18CREATE STATISTICS CREATE STATISTICS — 定义扩展统计信息大纲 CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON ( expression ) FROM table_name CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_na…CREATE STATISTICS CREATE SUBSCRIPTIONSQL 命令与语法本站词条定义一个新的订阅 CREATE SUBSCRIPTION subscription_name { SERVER server_name | CONNECTION 'conninfo' } PUBLICATION publication_name [, ...] [ WITH ( subscription_parameter [= value] [, ... ] ) ] 逻辑复…SQL 命令 · 逻辑复制 CREATE SUBSCRIPTION章节正文PG18CREATE SUBSCRIPTION CREATE SUBSCRIPTION — 定义一个新的订阅大纲 CREATE SUBSCRIPTION subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...] [ WITH ( subscription_parameter [= value…CREATE SUBSCRIPTION CREATE TABLE章节正文PG18CREATE TABLE CREATE TABLE — 定义一个新表大纲 CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ STORAGE { PLAIN | EXTERNAL…CREATE TABLE CREATE TABLE ASSQL 命令与语法本站词条根据查询结果定义一个新表 CREATE [ persistence_mode ] TABLE [ IF NOT EXISTS ] table_name [ ( column_name [, ...] ) ] [ USING method ] [ WITH ( storage_parameter [= value] [, ... ] ) | WITHOUT OIDS ] [ O…SQL 命令 · 表与视图 CREATE TABLE AS章节正文PG18CREATE TABLE AS CREATE TABLE AS — 根据查询结果定义一个新表大纲 CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name [ (column_name [, ...] ) ] [ USING method ] …CREATE TABLE AS CREATE TABLESPACESQL 命令与语法本站词条定义一个新表空间 CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ] LOCATION 'directory' [ WITH ( tablespace_option = value [, ... ] ) ] 数据库、模式与表…SQL 命令 · 数据库、模式与表空间 CREATE TABLESPACE章节正文PG18CREATE TABLESPACE CREATE TABLESPACE — 定义一个新表空间大纲 CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ] LOCATION 'directory' [ WITH ( tablespa…CREATE TABLESPACE CREATE TEXT SEARCH CONFIGURATIONSQL 命令与语法本站词条定义一个新的文本检索配置 CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config ) 全文检索SQL 命令 · 全文检索 CREATE TEXT SEARCH CONFIGURATION章节正文PG18CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH CONFIGURATION — 定义一个新的文本检索配置大纲 CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config )CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH DICTIONARYSQL 命令与语法本站词条定义一个新的文本检索词典 CREATE TEXT SEARCH DICTIONARY name ( TEMPLATE = template [, option = value [, ... ]] ) 全文检索SQL 命令 · 全文检索 CREATE TEXT SEARCH DICTIONARY章节正文PG18CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH DICTIONARY — 定义一个新的文本检索词典大纲 CREATE TEXT SEARCH DICTIONARY name ( TEMPLATE = template [, option = value [, ... ]] )CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH PARSERSQL 命令与语法本站词条定义一个新的文本检索解析器 CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = end_function , LEXTYPES = lextypes_function [, HEADLINE = headline_function ] ) …SQL 命令 · 全文检索 CREATE TEXT SEARCH PARSER章节正文PG18CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH PARSER — 定义一个新的文本检索解析器大纲 CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = end_function , LEXTYPES =…CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH TEMPLATESQL 命令与语法本站词条定义一个新的文本检索模板 CREATE TEXT SEARCH TEMPLATE name ( [ INIT = init_function , ] LEXIZE = lexize_function ) 全文检索SQL 命令 · 全文检索 CREATE TEXT SEARCH TEMPLATE章节正文PG18CREATE TEXT SEARCH TEMPLATE CREATE TEXT SEARCH TEMPLATE — 定义一个新的文本检索模板大纲 CREATE TEXT SEARCH TEMPLATE name ( [ INIT = init_function , ] LEXIZE = lexize_function )CREATE TEXT SEARCH TEMPLATE CREATE TRANSFORMSQL 命令与语法本站词条定义一个新的转换 CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_function_name [ (argument_type [, ...]) ], TO SQL WITH FUNCTION to_sql_function_n…SQL 命令 · 函数与过程 CREATE TRANSFORM章节正文PG18CREATE TRANSFORM CREATE TRANSFORM — 定义一个新的转换大纲 CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_function_name [ (argument_type [, ...]) ], T…CREATE TRANSFORM CREATE TRIGGERSQL 命令与语法本站词条定义一个新触发器 CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON table_name [ FROM referenced_table_name ] [ NOT DEFERRABLE | [ DEFERRABLE …SQL 命令 · 触发器与规则 CREATE TRIGGER章节正文PG18CREATE TRIGGER CREATE TRIGGER — 定义一个新触发器大纲 CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON table_name [ FROM referenced_table_name ]…CREATE TRIGGER CREATE TYPESQL 命令与语法本站词条定义一种新数据类型 CREATE TYPE name AS ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] ) CREATE TYPE name AS RANGE ( SUBTYPE = subty…SQL 命令 · 类型与运算符 CREATE TYPE章节正文PG18CREATE TYPE CREATE TYPE — 定义一种新数据类型大纲 CREATE TYPE name AS ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] ) CREATE TYPE name A…CREATE TYPE CREATE USERSQL 命令与语法本站词条定义一个新的数据库角色 CREATE USER name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN…SQL 命令 · 角色与权限 CREATE USER章节正文PG18CREATE USER CREATE USER — 定义一个新的数据库角色大纲 CREATE USER name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NO…CREATE USER CREATE USER MAPPINGSQL 命令与语法本站词条定义用户到外部服务器的新映射 CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER server_name [ OPTIONS ( option 'value' [ , ... ] ) ] 外部数据SQL 命令 · 外部数据 CREATE USER MAPPING章节正文PG18CREATE USER MAPPING CREATE USER MAPPING — 定义用户到外部服务器的新映射大纲 CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER server_name [ OPTIONS …CREATE USER MAPPING CREATE VIEWSQL 命令与语法本站词条定义一个新视图 CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_option_value] [, ... ] ) ] AS query [ WITH [ CASCADE…SQL 命令 · 表与视图 CREATE VIEW章节正文PG18CREATE VIEW CREATE VIEW — 定义一个新视图大纲 CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_option_value] [, ... ] ) …CREATE VIEW create_upper_paths_hook扩展钩子本站词条在分组、排序等上层查询阶段增补路径。 上层查询路径 查询规划 规划器建立上层关系的路径时调用此钩子，通过 UpperRelationKind 区分当前规划阶段。它提供输入关系和输出关系，扩展可向输出关系加入候选路径。PostgreSQL 11 起还传入该阶段的附加信息。 typedef void (*create_upper_paths_hook_type) (PlannerI…扩展钩子 · 查询规划 createdb命令行工具本站词条createdb — 创建新的 PostgreSQL 数据库 客户端程序 createdb [ connection-option ...] [ option ...] [ dbname [ description ]] 手册中的可执行程序 createdb 程序版本 10.23 参考清单 客户端程序 选项定义组 16 手册中的选项 指定数据库的默认表空间。（该名称将按双引号…命令行工具 · 客户端程序 createdb章节正文PG18createdb createdb — 创建新的 PostgreSQL 数据库大纲 createdb [connection-option...] [option...] [dbname [description]]createdb