CREATE_TEXT_SEARCH_PARSER(7pg13)

🌸 CREATE_TEXT_SEARCH_PARSER 🌸

okay so bestie, this is the CREATE_TEXT_SEARCH_PARSER(7pg13) page from the PostgreSQL 13.23 docs, and we're about to make a whole new text search parser. iconic behavior only 💅

---

💖 NAME 💖

CREATE_TEXT_SEARCH_PARSER — define 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. A parser is not particularly useful by itself, but 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.

⚠️ bestie, listen: 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, it's serious 😭

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 (a function that returns information about the set of token types it produces). 🧚
• headline_function — the name of the headline function for the parser (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. lowkey flexible, highkey important 💜

---

🌈 COMPATIBILITY 🌈

There is no CREATE TEXT SEARCH PARSER statement in the SQL standard. bestie, this one is PostgreSQL's own vibe 😌

---

👑 SEE ALSO 👑

• ALTER TEXT SEARCH PARSER (ALTER_TEXT_SEARCH_PARSER(7)) 🛠️
• DROP TEXT SEARCH PARSER (DROP_TEXT_SEARCH_PARSER(7)) 🗑️

---

later bestie 💜 this page came from the PostgreSQL 13.23 docs, dated 2025. slay and stay parsed ✨🌸