CREATE_TEXT_SEARCH_CONFIGURATION(7pg16)

🌸 NAME 🌸

okay so this is the CREATE_TEXT_SEARCH_CONFIGURATION(7pg16) page from the PostgreSQL 16.15 docs 💖 — and it's literally CREATE_TEXT_SEARCH_CONFIGURATION - define a new text search configuration. No cap, that's the whole point. 🫶

✨ SYNOPSIS ✨

the syntax is short and iconic:

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

💖 DESCRIPTION 💖

okay so CREATE TEXT SEARCH CONFIGURATION creates a brand-new text search configuration. A text search configuration specifies a text search parser — the thing that can divide a string into tokens — plus dictionaries that can be used to determine which tokens are of interest for searching. It's giving search-brain, and we love that. 🔥

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 — slay, reuse the vibe. ✨

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. main character energy, but make it ownership. 👑

refer to Chapter 12 for further information. iykyk. 🦋

🎀 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, bestie — you cannot use both. Why? Because when an existing configuration is copied, its parser selection is copied too. So yeah, they're not a combo meal. 🙅‍♀️

🌈 COMPATIBILITY 🌈

There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL standard. that's just the tea. 🙈

👑 SEE ALSO 👑

• ALTER TEXT SEARCH CONFIGURATION (ALTER_TEXT_SEARCH_CONFIGURATION(7))
• DROP TEXT SEARCH CONFIGURATION (DROP_TEXT_SEARCH_CONFIGURATION(7))

---

xoxo, PostgreSQL 16.15 · 2026 · CREATE_TEXT_SEARCH_CONFIGURATION(7pg16) 🎀💅