↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / System Catalogs

pg_ts_parser

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token type to each lexeme. Since a parser must be implemented by C-language-level functions, creation of new parsers is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12.

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

Reading PG 18·Select a recorded version

kind
catalog
lang
en
measured attributes
true
metadata release
18.6
runtime columns
oid, prsname, prsnamespace, prsstart, prstoken, prsend, prsheadline, prslextype
runtime verified
false
source
english-manual

Definition PG 18

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token type to each lexeme. Since a parser must be implemented by C-language-level functions, creation of new parsers is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12.

Catalog columns

ColumnTypeNullabilityDescription
oidoidNot nullRow identifier
prsnamenameNot nullText search parser name
prsnamespaceoidNot nullThe OID of the namespace that contains this parser
prsstartregprocNot nullOID of the parser's startup function
prstokenregprocNot nullOID of the parser's next-token function
prsendregprocNot nullOID of the parser's shutdown function
prsheadlineregprocNot nullOID of the parser's headline function (zero if none)
prslextyperegprocNot nullOID of the parser's lextype function

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:d0eee18ecec009856bad9e8fa28d1a6386cc6fdaa31b90a28a14f72e17cab41d

Text language: en · catalog-bilingual-repair:d0eee18ecec009856bad9e8fa28d1a6386cc6fdaa31b90a28a14f72e17cab41d