PostgreSQL 文档检索

64 位 Windows 的特殊注意事项章节正文PG1817.7.5.2. 64 位 Windows 的特殊注意事项 PostgreSQL 在 64 位 Windows 上只能构建为 x64 架构。不支持在同一个构建树中混用 32 位和 64 位版本。构建系统会自动检测自己是在 32 位还是 64 位环境中运行，并据此构建 PostgreSQL。因此，在开始构建之前启动正确的命令提示符非常重要。如果要使用服务器端第三方库，例如 Py…64 位 Windows 的特殊注意事项 ABI 兼容性章节正文PG1836.10.6.3. ABI 兼容性 ABI，即应用程序二进制接口，是运行时使用的接口。ABI 兼容性 ABORT章节正文PG18ABORT ABORT — 中止当前事务大纲 ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]ABORT administrable_role_​authorizations章节正文PG1835.4. administrable_role_​authorizations 视图administrable_role_authorizations标识当前用户对其有管理选项的所有角色。表 35.2. administrable_role_authorizations 列 列类型 描述 grantee sql_identifier 被授予该角色成员资格的角色名称（可以是当前…administrable_role_​authorizations ALIAS章节正文PG1841.3.2. ALIAS newname ALIAS FOR oldname; ALIAS 语法比上一节所展示的更一般化：你可以为任何变量声明别名，而不只是函数参数。它最主要的实际用途，是为那些名称预先固定的变量指定另一个名字，例如触发器函数中的 NEW 或 OLD。示例：DECLARE prior ALIAS FOR old; updated ALIAS FOR new; …ALIAS ALL章节正文PG189.24.5. ALL expression operator ALL (subquery) 右侧是一个用圆括号括起来的子查询，必须恰好返回一列。左侧表达式会被求值，并使用给定的operator与子查询结果的每一行进行比较。该操作符必须产生布尔结果。如果所有行都得到真（包括子查询不返回任何行的情况），则ALL的结果为“真”。如果得到任何假值结果，则结果为“假”。如果与任何子查询…ALL ALLOCATE DESCRIPTOR章节正文PG18ALLOCATE DESCRIPTOR ALLOCATE DESCRIPTOR — 分配一个 SQL 描述符区域大纲 ALLOCATE DESCRIPTOR nameALLOCATE DESCRIPTOR ALL（数组）章节正文PG189.25.4. ALL（数组）expression operator ALL (array expression) 右侧是一个用括号括起来的表达式，它必须产生一个数组值。左侧表达式会被求值，并使用给定的operator与数组的每个元素进行比较，该操作符必须产生布尔结果。如果所有比较都得到真值结果，那么ALL的结果是“真”（包括数组有零个元素的情况）。如果有任何假值结果，那么结果…ALL（数组） ALTER AGGREGATE章节正文PG18ALTER AGGREGATE ALTER AGGREGATE — 更改一个聚合函数的定义大纲 ALTER AGGREGATE name ( aggregate_signature ) RENAME TO new_name ALTER AGGREGATE name ( aggregate_signature ) OWNER TO { new_owner | CURRENT_RO…ALTER AGGREGATE ALTER COLLATION章节正文PG18ALTER COLLATION ALTER COLLATION — 更改排序规则的定义大纲 ALTER COLLATION name REFRESH VERSION ALTER COLLATION name RENAME TO new_name ALTER COLLATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_…ALTER COLLATION ALTER CONVERSION章节正文PG18ALTER CONVERSION ALTER CONVERSION — 更改一个转换的定义大纲 ALTER CONVERSION name RENAME TO new_name ALTER CONVERSION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER CONVE…ALTER CONVERSION ALTER DATABASE章节正文PG18ALTER DATABASE ALTER DATABASE — 更改一个数据库大纲 ALTER DATABASE name [ [ WITH ] option [ ... ] ] 其中option可以是： ALLOW_CONNECTIONS allowconn CONNECTION LIMIT connlimit IS_TEMPLATE istemplate ALTER DAT…ALTER DATABASE ALTER DEFAULT PRIVILEGES章节正文PG18ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES — 定义默认访问权限大纲 ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_rev…ALTER DEFAULT PRIVILEGES ALTER DOMAIN章节正文PG18ALTER DOMAIN ALTER DOMAIN — 更改一个域的定义大纲 ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name ADD domain_constraint [ NOT VAL…ALTER DOMAIN ALTER EVENT TRIGGER章节正文PG18ALTER EVENT TRIGGER ALTER EVENT TRIGGER — 更改事件触发器的定义大纲 ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGER name OWNER TO { new_owner | C…ALTER EVENT TRIGGER ALTER EXTENSION章节正文PG18ALTER EXTENSION ALTER EXTENSION — 更改扩展的定义大纲 ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION name ADD member_object ALTER EXTENSION n…ALTER EXTENSION ALTER FOREIGN DATA WRAPPER章节正文PG18ALTER FOREIGN DATA WRAPPER ALTER FOREIGN DATA WRAPPER — 更改外部数据包装器的定义大纲 ALTER FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO VALIDATOR…ALTER FOREIGN DATA WRAPPER ALTER FOREIGN TABLE章节正文PG18ALTER FOREIGN TABLE ALTER FOREIGN TABLE — 更改外部表的定义大纲 ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ COLU…ALTER FOREIGN TABLE ALTER FUNCTION章节正文PG18ALTER FUNCTION ALTER FUNCTION — 更改函数的定义大纲 ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTION name [ ( [ [ argmode ] [ argname …ALTER FUNCTION ALTER GROUP章节正文PG18ALTER GROUP ALTER GROUP — 更改角色名称或成员资格大纲 ALTER GROUP role_specification ADD USER user_name [, ... ] ALTER GROUP role_specification DROP USER user_name [, ... ] 其中 role_specification 可以是： role…ALTER GROUP ALTER INDEX章节正文PG18ALTER INDEX ALTER INDEX — 更改索引的定义大纲 ALTER INDEX [ IF EXISTS ] name RENAME TO new_name ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name ALTER INDEX name ATTACH PARTITION index_na…ALTER INDEX ALTER LANGUAGE章节正文PG18ALTER LANGUAGE ALTER LANGUAGE — 更改一种过程语言的定义大纲 ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SE…ALTER LANGUAGE ALTER LARGE OBJECT章节正文PG18ALTER LARGE OBJECT ALTER LARGE OBJECT — 更改一个大对象的定义大纲 ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }ALTER LARGE OBJECT ALTER MATERIALIZED VIEW章节正文PG18ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW — 更改一个物化视图的定义大纲 ALTER MATERIALIZED VIEW [ IF EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW name [ NO ] DEPENDS ON EXTENSION extension_…ALTER MATERIALIZED VIEW ALTER OPERATOR章节正文PG18ALTER OPERATOR ALTER OPERATOR — 更改一个操作符的定义大纲 ALTER OPERATOR name ( { left_type | NONE } , right_type ) OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER OPERATOR name…ALTER OPERATOR ALTER OPERATOR CLASS章节正文PG18ALTER OPERATOR CLASS ALTER OPERATOR CLASS — 更改一个操作符类的定义大纲 ALTER OPERATOR CLASS name USING index_method RENAME TO new_name ALTER OPERATOR CLASS name USING index_method OWNER TO { new_owner | …ALTER OPERATOR CLASS ALTER OPERATOR FAMILY章节正文PG18ALTER OPERATOR FAMILY ALTER OPERATOR FAMILY — 更改一个操作符族的定义大纲 ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name ( op_type, op_type ) [ FOR SEARCH | FOR…ALTER OPERATOR FAMILY ALTER POLICY章节正文PG18ALTER POLICY ALTER POLICY — 更改一条行级安全策略的定义大纲 ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSI…ALTER POLICY ALTER PROCEDURE章节正文PG18ALTER PROCEDURE ALTER PROCEDURE — 更改过程的定义大纲 ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PROCEDURE name [ ( [ [ argmode ] [ argn…ALTER PROCEDURE ALTER PUBLICATION章节正文PG18ALTER PUBLICATION ALTER PUBLICATION — 修改发布的定义大纲 ALTER PUBLICATION name ADD publication_object [, ...] ALTER PUBLICATION name SET publication_object [, ...] ALTER PUBLICATION name DROP public…ALTER PUBLICATION ALTER ROLE章节正文PG18ALTER ROLE ALTER ROLE — 更改数据库角色大纲 ALTER ROLE role_specification [ WITH ] option [ ... ] 其中option可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | N…ALTER ROLE ALTER ROUTINE章节正文PG18ALTER ROUTINE ALTER ROUTINE — 更改一个例程的定义大纲 ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] …ALTER ROUTINE ALTER RULE章节正文PG18ALTER RULE ALTER RULE — 修改一条重写规则的定义大纲 ALTER RULE name ON table_name RENAME TO new_nameALTER RULE ALTER SCHEMA章节正文PG18ALTER SCHEMA ALTER SCHEMA — 更改一个模式的定义大纲 ALTER SCHEMA name RENAME TO new_name ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }ALTER SCHEMA ALTER SEQUENCE章节正文PG18ALTER SEQUENCE ALTER SEQUENCE — 更改序列发生器的定义大纲 ALTER SEQUENCE [ IF EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MA…ALTER SEQUENCE ALTER SERVER章节正文PG18ALTER SERVER ALTER SERVER — 更改外部服务器的定义大纲 ALTER SERVER name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTER SERVER name OWNER TO { new_owner | C…ALTER SERVER ALTER STATISTICS章节正文PG18ALTER STATISTICS ALTER STATISTICS — 更改扩展统计对象的定义大纲 ALTER STATISTICS name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER STATISTICS name RENAME TO new_name ALTER STA…ALTER STATISTICS ALTER SUBSCRIPTION章节正文PG18ALTER SUBSCRIPTION ALTER SUBSCRIPTION — 修改订阅的定义大纲 ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...] [ WITH ( publication_option […ALTER SUBSCRIPTION ALTER SYSTEM章节正文PG18ALTER SYSTEM ALTER SYSTEM — 更改服务器配置参数大纲 ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } ALTER SYSTEM RESET configuration_parameter ALTER SYSTEM RESET ALLALTER SYSTEM ALTER TABLE章节正文PG18ALTER TABLE ALTER TABLE — 更改一个表的定义大纲ALTER TABLE