↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / SQL Commands

CREATE TEXT SEARCH CONFIGURATION

define a new text search configuration

English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

8.38.49.09.19.29.39.49.59.61011121314151617181920
anchor
SQL-CREATETSCONFIG
file
sql-createtsconfig.html
lang
en
name
CREATE TEXT SEARCH CONFIGURATION
purpose
define a new text search configuration
purpose zh
定义一个新的文本检索配置
sections same as
Unknown
slug
18
synopsis html
CREATE TEXT SEARCH CONFIGURATION <em class="replaceable"><code>name</code></em> ( PARSER = <em class="replaceable"><code>parser_name</code></em> | COPY = <em class="replaceable"><code>source_config</code></em> )
synopsis text
CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config )

Syntax

CREATE TEXT SEARCH CONFIGURATION name (
PARSER = parser_name |
COPY = source_config
)
Syntax diagrams

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

CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name COPY = source_config )

Definition PG 18

CREATE TEXT SEARCH CONFIGURATION name (
PARSER = parser_name |
COPY = source_config
)

Description

CREATE TEXT SEARCH CONFIGURATION creates a new text search configuration. A text search configuration specifies a text search parser that can divide a string into tokens, plus dictionaries that can be used to determine which tokens are of interest for searching.

If only the parser is specified, then the new text search configuration initially has no mappings from token types to dictionaries, and therefore will ignore all words. Subsequent ALTER TEXT SEARCH CONFIGURATION commands must be used to create mappings to make the configuration useful. Alternatively, an existing text search configuration can be copied.

If a schema name is given then the text search configuration is created in the specified schema. Otherwise it is created in the current schema.

The user who defines a text search configuration becomes its owner.

Refer to Chapter 12 for further information.

Parameters

name

The name of the text search configuration to be created. The name can be schema-qualified.

parser_name

The name of the text search parser to use for this configuration.

source_config

The name of an existing text search configuration to copy.

Notes

The PARSER and COPY options are mutually exclusive, because when an existing configuration is copied, its parser selection is copied too.

Compatibility

There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL standard.

See Also

ALTER TEXT SEARCH CONFIGURATION, DROP TEXT SEARCH CONFIGURATION

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:f57b08e7bf29504c8eeb5dcb2b98f9fd7ca3d43874e4628ce95e22486a4c5bd6

Text language: en · wiki-repair-20261023:f57b08e7bf29504c8eeb5dcb2b98f9fd7ca3d43874e4628ce95e22486a4c5bd6