↑↓ 选择 ↵ 打开 ⌫ 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译,由 Pigsty 团队维护。

PostgreSQL 文档检索

PG 18 · 按类别浏览,或输入名称与关键词

分类索引247
CREATE TABLESQL 命令与语法本站词条定义一个新表 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 命令 · 表与视图 EXPLAINSQL 命令与语法本站词条显示一个语句的执行计划 show the execution plan of a statement EXPLAIN [ ( option [, ...] ) ] statement where option can be one of: ANALYZE [ boolean ] VERBOSE [ boolean ] COSTS [ boolean ] SETTINGS [ …SQL 命令 · 查询与数据操作 SELECTSQL 命令与语法PG18空 SELECT 列表 SELECT 之后的输出表达式列表可以为空,这会产生一个零列的结果表。按照 SQL 标准,这不是合法的语法。PostgreSQL 允许这样做,是为了与允许零列的表保持一致。不过在使用 DISTINCT 时不允许空列表。SELECT › 兼容性 › 空 SELECT 列表 SELECTSQL 命令与语法本站词条从表或视图中检索行 retrieve rows from a table or view [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] [ { * | expression [ [ AS ] output_name ] } [, …SQL 命令 · 查询与数据操作 ABORTSQL 命令与语法本站词条中止当前事务 abort the current transaction ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] 事务控制SQL 命令 · 事务控制 ALLSQL 命令与语法PG189.25.4. ALL(数组)# expression operator ALL (array expression) 右侧是一个用括号括起来的表达式,它必须产生一个数组值。左侧表达式会被求值,并使用给定的 operator 与数组的每个元素进行比较,该操作符必须产生布尔结果。如果所有比较都得到真值结果,那么 ALL 的结果是“真”(包括数组有零个元素的情况)。如果有任何假值结…行和数组比较 › ALL(数组) ALTER AGGREGATESQL 命令与语法本站词条更改一个聚合函数的定义 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 COLLATIONSQL 命令与语法本站词条更改排序规则的定义 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 CONVERSIONSQL 命令与语法本站词条更改一个转换的定义 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 DATABASESQL 命令与语法本站词条更改一个数据库 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 PRIVILEGESSQL 命令与语法本站词条定义默认访问权限 define default access privileges ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revoke where abbreviated…SQL 命令 · 角色与权限 ALTER DOMAINSQL 命令与语法本站词条更改一个域的定义 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 TRIGGERSQL 命令与语法本站词条更改事件触发器的定义 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 EXTENSIONSQL 命令与语法本站词条更改扩展的定义 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 WRAPPERSQL 命令与语法本站词条更改外部数据包装器的定义 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 TABLESQL 命令与语法本站词条更改外部表的定义 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 FUNCTIONSQL 命令与语法本站词条更改函数的定义 change the definition of a function ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTION name [ ( [ [ argmode ] [ argnam…SQL 命令 · 函数与过程 ALTER GROUPSQL 命令与语法本站词条更改角色名称或成员资格 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 INDEXSQL 命令与语法本站词条更改索引的定义 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 LANGUAGESQL 命令与语法本站词条更改一种过程语言的定义 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 OBJECTSQL 命令与语法本站词条更改一个大对象的定义 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 VIEWSQL 命令与语法本站词条更改一个物化视图的定义 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 OPERATORSQL 命令与语法本站词条更改一个操作符的定义 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 CLASSSQL 命令与语法本站词条更改一个操作符类的定义 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 FAMILYSQL 命令与语法本站词条更改一个操作符族的定义 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 POLICYSQL 命令与语法本站词条更改一条行级安全策略的定义 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 PROCEDURESQL 命令与语法本站词条更改过程的定义 change the definition of a procedure ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PROCEDURE name [ ( [ [ argmode ] [ arg…SQL 命令 · 函数与过程 ALTER PUBLICATIONSQL 命令与语法本站词条修改发布的定义 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 ROLESQL 命令与语法本站词条更改数据库角色 change a database role ALTER ROLE role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHE…SQL 命令 · 角色与权限 ALTER ROUTINESQL 命令与语法本站词条更改一个例程的定义 change the definition of a routine ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE name [ ( [ [ argmode ] [ argname…SQL 命令 · 函数与过程 ALTER RULESQL 命令与语法本站词条修改一条重写规则的定义 change the definition of a rule ALTER RULE name ON table_name RENAME TO new_name 触发器与规则SQL 命令 · 触发器与规则 ALTER SCHEMASQL 命令与语法本站词条更改一个模式的定义 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 SEQUENCESQL 命令与语法本站词条更改序列发生器的定义 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 SERVERSQL 命令与语法本站词条更改外部服务器的定义 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 STATISTICSSQL 命令与语法本站词条更改扩展统计对象的定义 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 SUBSCRIPTIONSQL 命令与语法本站词条修改订阅的定义 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 SYSTEMSQL 命令与语法本站词条更改服务器配置参数 change a server configuration parameter ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } ALTER SYSTEM RESET configuration_parameter ALTER SYSTEM RES…SQL 命令 · 会话与参数 ALTER TABLESQL 命令与语法本站词条更改一个表的定义 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 TABLESPACESQL 命令与语法本站词条更改一个表空间的定义 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 CONFIGURATIONSQL 命令与语法本站词条更改一个文本检索配置的定义 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: 只搜扩展 ↑↓ 选择 ↵ 打开