PostgreSQL 文档检索

ALTER RULE章节正文PG18ALTER RULE ALTER RULE — 修改一条重写规则的定义大纲 ALTER RULE name ON table_name RENAME TO new_nameALTER RULE ALTER SCHEMASQL 命令与语法本站词条更改一个模式的定义 ALTER SCHEMA name RENAME TO new_name ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } 数据库、模式与表空间SQL 命令 · 数据库、模式与表空间 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 SEQUENCESQL 命令与语法本站词条更改序列发生器的定义 ALTER SEQUENCE [ IF EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ [ NO ] CYCLE ] [ START…SQL 命令 · 表与视图 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 SERVERSQL 命令与语法本站词条更改外部服务器的定义 ALTER SERVER name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | …SQL 命令 · 外部数据 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 STATISTICSSQL 命令与语法本站词条更改扩展统计对象的定义 ALTER STATISTICS name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER STATISTICS name RENAME TO new_name ALTER STATISTICS name SET SCHEMA new_schema AL…SQL 命令 · 索引与统计 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 SUBSCRIPTIONSQL 命令与语法本站词条修改订阅的定义 ALTER SUBSCRIPTION name SERVER server_name ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...] [ WITH ( publication_option…SQL 命令 · 逻辑复制 ALTER SUBSCRIPTION章节正文PG18ALTER SUBSCRIPTION ALTER SUBSCRIPTION — 修改订阅的定义大纲 ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...] [ WITH ( publication_option […ALTER SUBSCRIPTION ALTER SYSTEMSQL 命令与语法本站词条更改服务器配置参数 ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } ALTER SYSTEM RESET configuration_parameter ALTER SYSTEM RESET ALL 会话与参数SQL 命令 · 会话与参数 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 TABLESQL 命令与语法本站词条更改一个表的定义 ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ COLUMN ] column_name TO new_column_name ALTER TABLE [ IF EXISTS…SQL 命令 · 表与视图 ALTER TABLE章节正文PG18ALTER TABLE ALTER TABLE — 更改一个表的定义大纲ALTER TABLE ALTER TABLESPACESQL 命令与语法本站词条更改一个表空间的定义 ALTER TABLESPACE name RENAME TO new_name ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER TABLESPACE name SET ( tablespace_option =…SQL 命令 · 数据库、模式与表空间 ALTER TABLESPACE章节正文PG18ALTER TABLESPACE ALTER TABLESPACE — 更改一个表空间的定义大纲 ALTER TABLESPACE name RENAME TO new_name ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER TABL…ALTER TABLESPACE ALTER TEXT SEARCH CONFIGURATIONSQL 命令与语法本站词条更改一个文本检索配置的定义 ALTER TEXT SEARCH CONFIGURATION name ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ] ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING FOR token_type [, ...…SQL 命令 · 全文检索 ALTER TEXT SEARCH CONFIGURATION章节正文PG18ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION — 更改一个文本检索配置的定义大纲 ALTER TEXT SEARCH CONFIGURATION name ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ] ALTER…ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH DICTIONARYSQL 命令与语法本站词条更改一个文本检索词典的定义 ALTER TEXT SEARCH DICTIONARY name ( option [ = value ] [, ... ] ) ALTER TEXT SEARCH DICTIONARY name RENAME TO new_name ALTER TEXT SEARCH DICTIONARY name OWNER TO { new_owner |…SQL 命令 · 全文检索 ALTER TEXT SEARCH DICTIONARY章节正文PG18ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH DICTIONARY — 更改一个文本检索词典的定义大纲 ALTER TEXT SEARCH DICTIONARY name ( option [ = value ] [, ... ] ) ALTER TEXT SEARCH DICTIONARY name RENAME TO new_…ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH PARSERSQL 命令与语法本站词条更改一个文本检索解析器的定义 ALTER TEXT SEARCH PARSER name RENAME TO new_name ALTER TEXT SEARCH PARSER name SET SCHEMA new_schema 全文检索SQL 命令 · 全文检索 ALTER TEXT SEARCH PARSER章节正文PG18ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH PARSER — 更改一个文本检索解析器的定义大纲 ALTER TEXT SEARCH PARSER name RENAME TO new_name ALTER TEXT SEARCH PARSER name SET SCHEMA new_schemaALTER TEXT SEARCH PARSER ALTER TEXT SEARCH TEMPLATESQL 命令与语法本站词条更改一个文本检索模板的定义 ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schema 全文检索SQL 命令 · 全文检索 ALTER TEXT SEARCH TEMPLATE章节正文PG18ALTER TEXT SEARCH TEMPLATE ALTER TEXT SEARCH TEMPLATE — 更改一个文本检索模板的定义大纲 ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schemaALTER TEXT SEARCH TEMPLATE ALTER TRIGGERSQL 命令与语法本站词条更改触发器的定义 ALTER TRIGGER name ON table_name RENAME TO new_name ALTER TRIGGER name ON table_name [ NO ] DEPENDS ON EXTENSION extension_name 触发器与规则SQL 命令 · 触发器与规则 ALTER TRIGGER章节正文PG18ALTER TRIGGER ALTER TRIGGER — 更改触发器的定义大纲 ALTER TRIGGER name ON table_name RENAME TO new_name ALTER TRIGGER name ON table_name [ NO ] DEPENDS ON EXTENSION extension_nameALTER TRIGGER ALTER TYPESQL 命令与语法本站词条更改类型的定义 ALTER TYPE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER TYPE name RENAME TO new_name ALTER TYPE name SET SCHEMA new_schema ALTER TYPE name RENAME A…SQL 命令 · 类型与运算符 ALTER TYPE章节正文PG18ALTER TYPE ALTER TYPE — 更改类型的定义大纲 ALTER TYPE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER TYPE name RENAME TO new_name ALTER TYPE name SET SCHEMA new_schema…ALTER TYPE ALTER USERSQL 命令与语法本站词条更改数据库角色 ALTER USER role_specification [ WITH ] option [ ... ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NO…SQL 命令 · 角色与权限 ALTER USER章节正文PG18ALTER USER ALTER USER — 更改数据库角色大纲 ALTER USER role_specification [ WITH ] option [ ... ] 其中 option 可以是： SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT |…ALTER USER ALTER USER MAPPINGSQL 命令与语法本站词条更改用户映射的定义 ALTER USER MAPPING FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC } SERVER server_name OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) 外部数…SQL 命令 · 外部数据 ALTER USER MAPPING章节正文PG18ALTER USER MAPPING ALTER USER MAPPING — 更改用户映射的定义大纲 ALTER USER MAPPING FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC } SERVER server_name OPTIONS ( [ ADD | SET…ALTER USER MAPPING ALTER VIEWSQL 命令与语法本站词条更改视图的定义 ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name DROP DEFAULT ALTER VIEW [ IF EXISTS ] na…SQL 命令 · 表与视图 ALTER VIEW章节正文PG18ALTER VIEW ALTER VIEW — 更改视图的定义大纲 ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name DROP DEFAULT AL…ALTER VIEW amcheck扩展与模块PG18F.1. amcheck — 用于验证表和索引一致性的工具 amcheck 模块提供了一组函数，可用于验证关系结构的逻辑一致性。B-树检查函数会验证特定关系表示结构中的多种不变式。索引扫描以及其他重要操作背后的访问方法函数是否正确，依赖于这些不变式始终成立。例如，某些函数除其他事项外，还会验证所有 B-树页面中的项都按“逻辑”顺序排列（例如，对于 text 上的 B-树索引，索…amcheck — 用于验证表和索引一致性的工具 amcheck — 用于验证表和索引一致性的工具章节正文PG18F.1. amcheck — 用于验证表和索引一致性的工具 amcheck 模块提供了一组函数，可用于验证关系结构的逻辑一致性。B-树检查函数会验证特定关系表示结构中的多种不变式。索引扫描以及其他重要操作背后的访问方法函数是否正确，依赖于这些不变式始终成立。例如，某些函数除其他事项外，还会验证所有 B-树页面中的项都按“逻辑”顺序排列（例如，对于 text 上的 B-树索引，索…amcheck — 用于验证表和索引一致性的工具 amqp扩展与模块扩展目录允许 PostgreSQL 语句向 AMQP 消息代理发布消息。 Publish messages to AMQP brokers from PostgreSQL amqp messaging rabbitmq pg_amqp 复制与数据流复制与数据流 · 扩展目录 ANALYZESQL 命令与语法本站词条收集数据库的统计信息 ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] 其中option可以是下列之一： VERBOSE [ boolean ] SKIP_LOCKED [ boolean ] BUFFER_USAGE_LIMIT size 其中table_and_columns是： [ ONLY …SQL 命令 · 维护 ANALYZE章节正文PG18ANALYZE ANALYZE — 收集数据库的统计信息大纲 ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] 其中option可以是下列之一： VERBOSE [ boolean ] SKIP_LOCKED [ boolean ] BUFFER_USAGE_LIMIT size 其中table_and_c…ANALYZE