↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SQL Commands / Text Search

ALTER TEXT SEARCH PARSER

Read the PG 18 manual

change the definition of a text search parser

Reading PG 18current·documented in 20 of 30 versions, 8.3 to 20

Syntax

ALTER TEXT SEARCH PARSER name RENAME TO new_name
ALTER TEXT SEARCH PARSER name SET SCHEMA new_schema
Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

ALTER TEXT SEARCH PARSER name RENAME TO new_name
ALTER TEXT SEARCH PARSER · Syntax 2
ALTER TEXT SEARCH PARSER name SET SCHEMA new_schema

Description

ALTER TEXT SEARCH PARSER changes the definition of a text search parser. Currently, the only supported functionality is to change the parser's name.

You must be a superuser to use ALTER TEXT SEARCH PARSER.

Parameters

name

The name (optionally schema-qualified) of an existing text search parser.

new_name

The new name of the text search parser.

new_schema

The new schema for the text search parser.

Compatibility

There is no ALTER TEXT SEARCH PARSER statement in the SQL standard.

See Also

CREATE TEXT SEARCH PARSER, DROP TEXT SEARCH PARSER
Version history 3
  1. 9.0 → 9.1 changed
  2. 8.4 → 9.0 changed
  3. 8.2 → 8.3 added

Related entries

Definition snapshot: b7bd9cda · English manual source