CREATE_TEXT_SEARCH_PARSER(7pg15)

💖 NAME 💖

okay so, bestie, this is the CREATE_TEXT_SEARCH_PARSER(7pg15) page from the PostgreSQL 15.19 Documentation, and it’s literally the command for defining a new text search parser. ✨

✨ SYNOPSIS ✨

CREATE TEXT SEARCH PARSER name (
    START = start_function ,
    GETTOKEN = gettoken_function ,
    END = end_function ,
    LEXTYPES = lextypes_function
    [, HEADLINE = headline_function ]
)

🦋 DESCRIPTION 🦋

CREATE TEXT SEARCH PARSER creates a new text search parser. A text search parser defines a method for splitting a text string into tokens and assigning types (categories) to the tokens. On its own, a parser is not particularly useful by itself, but it must be bound into a text search configuration along with some text search dictionaries to be used for searching. 🫶

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

🚨 You must be a superuser to use CREATE TEXT SEARCH PARSER. This restriction is made because an erroneous text search parser definition could confuse or even crash the server. no cap, be careful with this one 💀

Refer to Chapter 12 for further information.

🎀 PARAMETERS 🎀

• name — the name of the text search parser to be created. The name can be schema-qualified.
• start_function — the name of the start function for the parser.
• gettoken_function — the name of the get-next-token function for the parser.
• end_function — the name of the end function for the parser.
• lextypes_function — the name of the lextypes function for the parser, aka a function that returns information about the set of token types it produces.
• headline_function — the name of the headline function for the parser, aka a function that summarizes a set of tokens.

The function names can be schema-qualified if necessary. Argument types are not given, since the argument list for each type of function is predetermined. All except the headline function are required. 👑

The arguments can appear in any order, not only the one shown above. yes bestie, any order you like 💅

🌈 COMPATIBILITY 🌈

There is no CREATE TEXT SEARCH PARSER statement in the SQL standard. that’s just the tea ☕

👑 SEE ALSO 👑

• ALTER TEXT SEARCH PARSER (ALTER_TEXT_SEARCH_PARSER(7))
• DROP TEXT SEARCH PARSER (DROP_TEXT_SEARCH_PARSER(7))

---

okay bye bestie 💋 this page’s source/version is PostgreSQL 15.19, and the date on it is 2026. mwah 💖