PostgreSQL 文档检索

CREATE COLLATION章节正文PG18CREATE COLLATION CREATE COLLATION — 定义一种新排序规则大纲 CREATE COLLATION [ IF NOT EXISTS ] name ( [ LOCALE = locale, ] [ LC_COLLATE = lc_collate, ] [ LC_CTYPE = lc_ctype, ] [ PROVIDER = provider, ] …CREATE COLLATION CREATE CONVERSIONSQL 命令与语法本站词条定义一个新的编码转换 CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM function_name 类型与运算符SQL 命令 · 类型与运算符 CREATE CONVERSION章节正文PG18CREATE CONVERSION CREATE CONVERSION — 定义一个新的编码转换大纲 CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM function_nameCREATE CONVERSION CREATE DATABASESQL 命令与语法本站词条创建一个新数据库 CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ STRATEGY [=] strategy ] [ LOCALE [=] locale ] [ LC_COLLATE [=] lc_collat…SQL 命令 · 数据库、模式与表空间 CREATE DATABASE章节正文PG18CREATE DATABASE CREATE DATABASE — 创建一个新数据库大纲 CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ STRATEGY [=] strategy ] [ LOCALE [=] …CREATE DATABASE CREATE DOMAINSQL 命令与语法本站词条定义一个新域 CREATE DOMAIN name [ AS ] data_type [ COLLATE collation ] [ DEFAULT expression ] [ domain_constraint [ ... ] ] 其中 domain_constraint 是： [ CONSTRAINT constraint_name ] { NOT NULL | N…SQL 命令 · 类型与运算符 CREATE DOMAIN章节正文PG18CREATE DOMAIN CREATE DOMAIN — 定义一个新域大纲 CREATE DOMAIN name [ AS ] data_type [ COLLATE collation ] [ DEFAULT expression ] [ domain_constraint [ ... ] ] 其中 domain_constraint 是： [ CONSTRAINT con…CREATE DOMAIN CREATE EVENT TRIGGERSQL 命令与语法本站词条定义一个新的事件触发器 CREATE EVENT TRIGGER name ON event [ WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ] ] EXECUTE { FUNCTION | PROCEDURE } function_name() 触发器与规则SQL 命令 · 触发器与规则 CREATE EVENT TRIGGER章节正文PG18CREATE EVENT TRIGGER CREATE EVENT TRIGGER — 定义一个新的事件触发器大纲 CREATE EVENT TRIGGER name ON event [ WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ] ] EXECUTE { FUNCTION | PROCEDURE } …CREATE EVENT TRIGGER CREATE EXTENSIONSQL 命令与语法本站词条安装一个扩展 CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ CASCADE ] 扩展与访问方法SQL 命令 · 扩展与访问方法 CREATE EXTENSION章节正文PG18CREATE EXTENSION CREATE EXTENSION — 安装一个扩展大纲 CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ CASCADE ]CREATE EXTENSION CREATE FOREIGN DATA WRAPPERSQL 命令与语法本站词条定义一个新的外部数据包装器 CREATE FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO VALIDATOR ] [ CONNECTION connection_function | NO CONNECTION ] […SQL 命令 · 外部数据 CREATE FOREIGN DATA WRAPPER章节正文PG18CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPER — 定义一个新的外部数据包装器大纲 CREATE FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO VALID…CREATE FOREIGN DATA WRAPPER CREATE FOREIGN TABLESQL 命令与语法本站词条定义一个新外部表 CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ COLLATE collation ] [ column_constraint [ ... ] ] | table_co…SQL 命令 · 外部数据 CREATE FOREIGN TABLE章节正文PG18CREATE FOREIGN TABLE CREATE FOREIGN TABLE — 定义一个新外部表大纲 CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ COLLATE collati…CREATE FOREIGN TABLE CREATE FUNCTIONSQL 命令与语法本站词条定义一个新函数 CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) [ RETURNS rettype | RETURNS TABLE ( column_name column_type [, .…SQL 命令 · 函数与过程 CREATE FUNCTION章节正文PG18CREATE FUNCTION CREATE FUNCTION — 定义一个新函数大纲 CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) [ RETURNS rettype | RETURNS T…CREATE FUNCTION CREATE GROUPSQL 命令与语法本站词条定义一个新的数据库角色 CREATE GROUP name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGI…SQL 命令 · 角色与权限 CREATE GROUP章节正文PG18CREATE GROUP CREATE GROUP — 定义一个新的数据库角色大纲 CREATE GROUP name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT |…CREATE GROUP CREATE INDEXSQL 命令与语法本站词条定义一个新索引 CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { column_name | ( expression ) } [ COLLATE collation ] [ opclass [ ( op…SQL 命令 · 索引与统计 CREATE INDEX章节正文PG18CREATE INDEX CREATE INDEX — 定义一个新索引大纲 CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { column_name | ( expression ) } [ COLLATE…CREATE INDEX CREATE INDEX 进度报告章节正文PG1827.4.4. CREATE INDEX 进度报告每当运行 CREATE INDEX 或 REINDEX 时，pg_stat_progress_create_index 视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。表 27.43. pg_stat_progress_create_index 视图 列类型 描述 pid …CREATE INDEX 进度报告 CREATE LANGUAGESQL 命令与语法本站词条定义一种新的过程语言 CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ INLINE inline_handler ] [ VALIDATOR valfunction ] CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCED…SQL 命令 · 函数与过程 CREATE LANGUAGE章节正文PG18CREATE LANGUAGE CREATE LANGUAGE — 定义一种新的过程语言大纲 CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ INLINE inline_handler ] [ VALIDATOR valfunction ] CREATE …CREATE LANGUAGE CREATE MATERIALIZED VIEWSQL 命令与语法本站词条定义一个新物化视图 CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ (column_name [, ...] ) ] [ USING method ] [ WITH ( storage_parameter [= value] [, ... ] ) ] [ TABLESPACE tablespace_name ] …SQL 命令 · 表与视图 CREATE MATERIALIZED VIEW章节正文PG18CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW — 定义一个新物化视图大纲 CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ (column_name [, ...] ) ] [ USING method ] [ WITH ( storage_parameter […CREATE MATERIALIZED VIEW CREATE OPERATORSQL 命令与语法本站词条定义一个新的操作符 CREATE OPERATOR name ( {FUNCTION|PROCEDURE} = function_name [, LEFTARG = left_type ] , RIGHTARG = right_type [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc …SQL 命令 · 类型与运算符 CREATE OPERATOR章节正文PG18CREATE OPERATOR CREATE OPERATOR — 定义一个新的操作符大纲 CREATE OPERATOR name ( {FUNCTION|PROCEDURE} = function_name [, LEFTARG = left_type ] [, RIGHTARG = right_type ] [, COMMUTATOR = com_op ] [, NEGA…CREATE OPERATOR CREATE OPERATOR CLASSSQL 命令与语法本站词条定义一个新的操作符类 CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY family_name ] AS { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ FOR SEA…SQL 命令 · 类型与运算符 CREATE OPERATOR CLASS章节正文PG18CREATE OPERATOR CLASS CREATE OPERATOR CLASS — 定义一个新的操作符类大纲 CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY family_name ] AS { OPERATOR strategy_number o…CREATE OPERATOR CLASS CREATE OPERATOR FAMILYSQL 命令与语法本站词条定义一个新的操作符族 CREATE OPERATOR FAMILY name USING index_method 类型与运算符SQL 命令 · 类型与运算符 CREATE OPERATOR FAMILY章节正文PG18CREATE OPERATOR FAMILY CREATE OPERATOR FAMILY — 定义一个新的操作符族大纲 CREATE OPERATOR FAMILY name USING index_methodCREATE OPERATOR FAMILY CREATE POLICYSQL 命令与语法本站词条为一个表定义一条新的行级安全策略 CREATE POLICY name ON table_name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ] [ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_…SQL 命令 · 角色与权限 CREATE POLICY章节正文PG18CREATE POLICY CREATE POLICY — 为一个表定义一条新的行级安全策略大纲 CREATE POLICY name ON table_name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ] [ TO { role_name | P…CREATE POLICY CREATE PROCEDURESQL 命令与语法本站词条定义一个新过程 CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LANGUAGE lang_name | TRANSFORM { FOR TYPE type_name } [, ... …SQL 命令 · 函数与过程 CREATE PROCEDURE章节正文PG18CREATE PROCEDURE CREATE PROCEDURE — 定义一个新过程大纲 CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LANGUAGE lang_name | TRA…CREATE PROCEDURE CREATE PUBLICATIONSQL 命令与语法本站词条定义一个新的发布 CREATE PUBLICATION name [ FOR { publication_object [, ... ] | publication_all_object [, ... ] } ] [ WITH ( publication_parameter [= value] [, ... ] ) ] 其中publication_object可以是： T…SQL 命令 · 逻辑复制 CREATE PUBLICATION章节正文PG18CREATE PUBLICATION CREATE PUBLICATION — 定义一个新的发布大纲 CREATE PUBLICATION name [ FOR ALL TABLES | FOR publication_object [, ... ] ] [ WITH ( publication_parameter [= value] [, ... ] ) ] 其中public…CREATE PUBLICATION CREATE ROLESQL 命令与语法本站词条定义一个新的数据库角色 CREATE ROLE name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN…SQL 命令 · 角色与权限 CREATE ROLE章节正文PG18CREATE ROLE CREATE ROLE — 定义一个新的数据库角色大纲 CREATE ROLE name [ [ WITH ] option [ ... ] ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NO…CREATE ROLE