{"kind": "fts", "major": "18", "item": {"slug": "configuration-estonian", "name": "estonian", "name_zh": "", "category": "\u914d\u7f6e", "summary": "\u5168\u6587\u68c0\u7d22\u914d\u7f6e estonian\u3002", "aliases": [], "content_hash": "a068995e6b6e64d7892620e2c72f09ed128a1cc8a4672245b10254fb5d775e05", "versions": {"18": {"facts": [{"label": "\u914d\u7f6e", "value": "estonian"}, {"label": "\u89e3\u6790\u5668", "value": "\u9ed8\u8ba4"}], "tables": [{"key": "mappings", "rows": [{"token": "email", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "url", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "url_path", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "host", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "file", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "version", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "sfloat", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "float", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "int", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "uint", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "numword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "hword_numpart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "numhword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "asciiword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword_asciipart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "asciihword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "word", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword_part", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}], "title": "\u8bcd\u5143\u5230\u8bcd\u5178\u7684\u6620\u5c04", "columns": [{"key": "token", "label": "\u8bcd\u5143\u7c7b\u578b"}, {"key": "sequence", "label": "\u987a\u5e8f"}, {"key": "dictionary", "label": "\u8bcd\u5178"}]}], "aliases": [], "related": [{"url": "/wiki/fts/parser-default/?v=18", "label": "\u9ed8\u8ba4\u89e3\u6790\u5668"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/textsearch-configuration.html", "path": "textsearch-configuration.html", "label": "PostgreSQL 18 English manual", "sha256": "7957c03871a5f267f642ec609b2e3d1404eb000ccdef21ca0d1d8a8616110dc9", "language": "en", "original_url": "/docs/18/textsearch-configuration.html"}], "mappings": [{"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}], "sections": [{"code": "/*\n * text search configuration for estonian language\n *\n * Copyright (c) 2007-2025, PostgreSQL Global Development Group\n *\n * src/backend/snowball/snowball.sql.in\n *\n * estonian and certain other macros are replaced for each language;\n * see the Makefile for details.\n *\n * Note: this file is read in single-user -j mode, which means that the\n * command terminator is semicolon-newline-newline; whenever the backend\n * sees that, it stops and executes what it's got.  If you write a lot of\n * statements without empty lines between, they'll all get quoted to you\n * in any error message about one of them, so don't do that.  Also, you\n * cannot write a semicolon immediately followed by an empty line in a\n * string literal (including a function body!) or a multiline comment.\n */\n\nCREATE TEXT SEARCH DICTIONARY estonian_stem\n\t(TEMPLATE = snowball, Language = estonian );\n\nCOMMENT ON TEXT SEARCH DICTIONARY estonian_stem IS 'snowball stemmer for estonian language';\n\nCREATE TEXT SEARCH CONFIGURATION estonian\n\t(PARSER = default);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION estonian IS 'configuration for estonian language';\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n\tFOR email, url, url_path, host, file, version,\n\t    sfloat, float, int, uint,\n\t    numword, hword_numpart, numhword\n\tWITH simple;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR asciiword, hword_asciipart, asciihword\n\tWITH estonian_stem;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR word, hword_part, hword\n\tWITH estonian_stem;", "title": "initdb \u751f\u6210\u7684\u5b9a\u4e49", "paragraphs": ["\u6839\u636e\u6b64\u7248\u672c\u7684 Snowball \u8bed\u8a00\u5217\u8868\u548c SQL \u6a21\u677f\u751f\u6210\u3002"]}], "signature": "", "attributes": {"parser": "default", "configuration": "estonian"}, "description": ["\u5168\u6587\u68c0\u7d22\u914d\u7f6e estonian\u3002"], "manual_html": "<div class=\"sect1\" id=\"TEXTSEARCH-CONFIGURATION\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h2 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h2 class=\"title\" style=\"clear: both\">12.7.\u00a0\u914d\u7f6e\u793a\u4f8b </h2>\n</div>\n</div>\n</h2>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6307\u5b9a\u4e86\u5c06\u4e00\u4e2a\u6587\u6863\u8f6c\u6362\u6210\u4e00\u4e2a<code class=\"type\">tsvector</code>\u6240\u9700\u7684\u6240\u6709\u9009\u9879\uff1a\u7528\u4e8e\u628a\u6587\u672c\u5206\u89e3\u6210\u8bcd\u5143\u7684\u89e3\u6790\u5668\uff0c\u4ee5\u53ca\u7528\u4e8e\u5c06\u6bcf\u4e00\u4e2a\u8bcd\u5143\u8f6c\u6362\u6210\u8bcd\u4f4d\u7684\u8bcd\u5178\u3002\u6bcf\u4e00\u6b21<code class=\"function\">to_tsvector</code>\u6216<code class=\"function\">to_tsquery</code>\u7684\u8c03\u7528\u90fd\u9700\u8981\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6765\u6267\u884c\u5176\u5904\u7406\u3002\u914d\u7f6e\u53c2\u6570<a class=\"xref\" href=\"/docs/18/runtime-config-client.html#GUC-DEFAULT-TEXT-SEARCH-CONFIG\">default_text_search_config</a>\u6307\u5b9a\u4e86\u9ed8\u8ba4\u914d\u7f6e\u7684\u540d\u79f0\uff0c\u5982\u679c\u7701\u7565\u4e86\u663e\u5f0f\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u6587\u672c\u68c0\u7d22\u51fd\u6570\u5c06\u4f1a\u4f7f\u7528\u5b83\u3002\u5b83\u53ef\u4ee5\u5728<code class=\"filename\">postgresql.conf</code>\u4e2d\u8bbe\u7f6e\uff0c\u6216\u8005\u4f7f\u7528<code class=\"command\">SET</code>\u547d\u4ee4\u4e3a\u4e00\u4e2a\u5355\u72ec\u7684\u4f1a\u8bdd\u8bbe\u7f6e\u3002</p>\n<p lang=\"zh\">\u6709\u4e00\u4e9b\u9884\u5b9a\u4e49\u7684\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u53ef\u7528\uff0c\u5e76\u4e14\u4f60\u53ef\u4ee5\u5bb9\u6613\u5730\u521b\u5efa\u81ea\u5b9a\u4e49\u7684\u914d\u7f6e\u3002\u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e00\u7ec4<acronym class=\"acronym\">SQL</acronym>\u547d\u4ee4\uff0c\u5e76\u4e14\u6709\u591a\u4e2a<span class=\"application\">psql</span>\u547d\u4ee4\u53ef\u4ee5\u663e\u793a\u6709\u5173\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff08<a class=\"xref\" href=\"/docs/18/textsearch-psql.html\" title=\"12.10.\u00a0psql \u652f\u6301\">\u7b2c\u00a012.10\u00a0\u8282</a>\uff09\u7684\u4fe1\u606f\u3002</p>\n<p lang=\"zh\">\u4f5c\u4e3a\u4e00\u4e2a\u793a\u4f8b\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u914d\u7f6e<code class=\"literal\">pg</code>\uff0c\u4ece\u590d\u5236\u5185\u7f6e\u7684<code class=\"literal\">english</code>\u914d\u7f6e\u5f00\u59cb\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH CONFIGURATION public.pg ( COPY = pg_catalog.english );\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5c06\u4f7f\u7528\u4e00\u4e2a PostgreSQL \u76f8\u5173\u7684\u540c\u4e49\u8bcd\u5217\u8868\uff0c\u5e76\u5c06\u5b83\u5b58\u50a8\u5728<code class=\"filename\">$SHAREDIR/tsearch_data/pg_dict.syn</code>\u4e2d\u3002\u6587\u4ef6\u5185\u5bb9\u770b\u8d77\u6765\u50cf\uff1a</p>\n<pre class=\"programlisting\">postgres    pg\npgsql       pg\npostgresql  pg\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5b9a\u4e49\u540c\u4e49\u8bcd\u8bcd\u5178\u5982\u4e0b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY pg_dict (\n    TEMPLATE = synonym,\n    SYNONYMS = pg_dict\n);\n</pre>\n<p lang=\"zh\">\u63a5\u4e0b\u6765\u6211\u4eec\u6ce8\u518c<span class=\"productname\">Ispell</span>\u8bcd\u5178<code class=\"literal\">english_ispell</code>\uff0c\u5b83\u6709\u5176\u81ea\u5df1\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY english_ispell (\n    TEMPLATE = ispell,\n    DictFile = english,\n    AffFile = english,\n    StopWords = english\n);\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u5728\u914d\u7f6e<code class=\"literal\">pg</code>\u4e2d\u5efa\u7acb\u8bcd\u7684\u6620\u5c04\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,\n                      word, hword, hword_part\n    WITH pg_dict, english_ispell, english_stem;\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u9009\u62e9\u4e0d\u7d22\u5f15\u6216\u641c\u7d22\u67d0\u4e9b\u5185\u7f6e\u914d\u7f6e\u786e\u5b9e\u5904\u7406\u7684\u8bcd\u5143\u7c7b\u578b\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    DROP MAPPING FOR email, url, url_path, sfloat, float;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u6211\u4eec\u7684\u914d\u7f6e\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM ts_debug('public.pg', '\nPostgreSQL, the highly scalable, SQL compliant, open source object-relational\ndatabase management system, is now undergoing beta testing of the next\nversion of our software.\n');\n</pre>\n<p lang=\"zh\">\u4e0b\u4e00\u6b65\u662f\u628a\u4f1a\u8bdd\u8bbe\u7f6e\u4e3a\u4f7f\u7528\u8fd9\u4e2a\u65b0\u914d\u7f6e\uff0c\u8be5\u914d\u7f6e\u662f\u5728 <code class=\"literal\">public</code> \u6a21\u5f0f\u4e2d\u521b\u5efa\u7684\uff1a</p>\n<pre class=\"screen\">=&gt; \\dF\n   List of text search configurations\n Schema  | Name | Description\n---------+------+-------------\n public  | pg   |\n\nSET default_text_search_config = 'public.pg';\nSET\n\nSHOW default_text_search_config;\n default_text_search_config\n----------------------------\n public.pg\n</pre>\n</div>", "manual_path": "/docs/18/textsearch-configuration.html", "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-amproc.html", "method": "same-major semantic node", "sha256": "c1b7d16e812991b4d5fb68085a27c8ff82aeaffa34afda56c5837f9b7588187c", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMPROC/p[5]/span[2]/span[0]"]}, {"url": "/docs/18/textsearch-configuration.html", "method": "same-major semantic node", "sha256": "7f803d5b93ebfbc7277584f660e479e20eda950c121e0bb8a1e3ecd81268870c", "language": "zh", "matched_nodes": ["#TEXTSEARCH-CONFIGURATION/div[0]", "#TEXTSEARCH-CONFIGURATION/p[11]", "#TEXTSEARCH-CONFIGURATION/p[13]", "#TEXTSEARCH-CONFIGURATION/p[15]", "#TEXTSEARCH-CONFIGURATION/p[17]", "#TEXTSEARCH-CONFIGURATION/p[1]", "#TEXTSEARCH-CONFIGURATION/p[2]", "#TEXTSEARCH-CONFIGURATION/p[3]", "#TEXTSEARCH-CONFIGURATION/p[5]", "#TEXTSEARCH-CONFIGURATION/p[7]", "#TEXTSEARCH-CONFIGURATION/p[9]"]}, {"url": "/docs/18/using-explain.html", "method": "same-major semantic node", "sha256": "b8835ec9adbc70ec150667a6b5443f8d298222dc0cc8c2bd1abb1c1d64895904", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Text search configuration estonian.", "/versions/18/facts/0/label": "Configuration", "/versions/18/facts/1/label": "Parser", "/versions/18/facts/1/value": "default", "/versions/18/tables/0/title": "Token-to-dictionary mappings", "/versions/18/related/0/label": "default parser", "/versions/18/sections/0/title": "Generated initdb definition", "/versions/18/sections/0/paragraphs/0": "Generated from this release\u2019s Snowball language list and SQL template.", "/versions/18/tables/0/columns/0/label": "Token type", "/versions/18/tables/0/columns/1/label": "Order", "/versions/18/tables/0/columns/2/label": "Dictionary", "/versions/18/tables/0/rows/0/dictionary/text": "simple", "/versions/18/tables/0/rows/1/dictionary/text": "simple", "/versions/18/tables/0/rows/2/dictionary/text": "simple", "/versions/18/tables/0/rows/3/dictionary/text": "simple", "/versions/18/tables/0/rows/4/dictionary/text": "simple", "/versions/18/tables/0/rows/5/dictionary/text": "simple", "/versions/18/tables/0/rows/6/dictionary/text": "simple", "/versions/18/tables/0/rows/7/dictionary/text": "simple", "/versions/18/tables/0/rows/8/dictionary/text": "simple", "/versions/18/tables/0/rows/9/dictionary/text": "simple", "/versions/18/tables/0/rows/10/dictionary/text": "simple", "/versions/18/tables/0/rows/11/dictionary/text": "simple", "/versions/18/tables/0/rows/12/dictionary/text": "simple"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e802d122036da026cc651d51a639619c337cf6f5b57242243f2f1cfb576c14a8"}, "comparison_data": {"parser": "default", "mappings": [{"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}]}, "comparison_hash": "334adb6ccf3840b3ae28576d5a95dd2994f0698720fa793f5e5450e4b70d958b", "manual_language": "zh"}, "19": {"facts": [{"label": "\u914d\u7f6e", "value": "estonian"}, {"label": "\u89e3\u6790\u5668", "value": "\u9ed8\u8ba4"}], "tables": [{"key": "mappings", "rows": [{"token": "email", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "url", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "url_path", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "host", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "file", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "version", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "sfloat", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "float", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "int", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "uint", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "numword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "hword_numpart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "numhword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=19", "text": "\u7b80\u5355"}}, {"token": "asciiword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}, {"token": "hword_asciipart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}, {"token": "asciihword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}, {"token": "word", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}, {"token": "hword_part", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}, {"token": "hword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=19", "text": "estonian_stem"}}], "title": "\u8bcd\u5143\u5230\u8bcd\u5178\u7684\u6620\u5c04", "columns": [{"key": "token", "label": "\u8bcd\u5143\u7c7b\u578b"}, {"key": "sequence", "label": "\u987a\u5e8f"}, {"key": "dictionary", "label": "\u8bcd\u5178"}]}], "aliases": [], "related": [{"url": "/wiki/fts/parser-default/?v=19", "label": "\u9ed8\u8ba4\u89e3\u6790\u5668"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "catalog_fingerprint": "62fbf1a3689dbe8bf7e6b3372cfe6fbf867581427b3858a94c8419b77a4d2d1d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/textsearch-configuration.html", "path": "textsearch-configuration.html", "label": "PostgreSQL 19 English manual", "sha256": "89d047816e375228f2d4567d524efa447b563a1cd55e9fdf53481f0ab4ca1203", "language": "en", "original_url": "/docs/19/textsearch-configuration.html"}], "mappings": [{"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}], "sections": [{"code": "/*\n * text search configuration for estonian language\n *\n * Copyright (c) 2007-2026, PostgreSQL Global Development Group\n *\n * src/backend/snowball/snowball.sql.in\n *\n * estonian and certain other macros are replaced for each language;\n * see the Makefile for details.\n *\n * Note: this file is read in single-user -j mode, which means that the\n * command terminator is semicolon-newline-newline; whenever the backend\n * sees that, it stops and executes what it's got.  If you write a lot of\n * statements without empty lines between, they'll all get quoted to you\n * in any error message about one of them, so don't do that.  Also, you\n * cannot write a semicolon immediately followed by an empty line in a\n * string literal (including a function body!) or a multiline comment.\n */\n\nCREATE TEXT SEARCH DICTIONARY estonian_stem\n\t(TEMPLATE = snowball, Language = estonian );\n\nCOMMENT ON TEXT SEARCH DICTIONARY estonian_stem IS 'snowball stemmer for estonian language';\n\nCREATE TEXT SEARCH CONFIGURATION estonian\n\t(PARSER = default);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION estonian IS 'configuration for estonian language';\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n\tFOR email, url, url_path, host, file, version,\n\t    sfloat, float, int, uint,\n\t    numword, hword_numpart, numhword\n\tWITH simple;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR asciiword, hword_asciipart, asciihword\n\tWITH estonian_stem;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR word, hword_part, hword\n\tWITH estonian_stem;", "title": "initdb \u751f\u6210\u7684\u5b9a\u4e49", "paragraphs": ["\u6839\u636e\u6b64\u7248\u672c\u7684 Snowball \u8bed\u8a00\u5217\u8868\u548c SQL \u6a21\u677f\u751f\u6210\u3002"]}], "signature": "", "attributes": {"parser": "default", "configuration": "estonian"}, "description": ["\u5168\u6587\u68c0\u7d22\u914d\u7f6e estonian\u3002"], "manual_html": "<div class=\"sect1\" id=\"TEXTSEARCH-CONFIGURATION\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h2 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h2 class=\"title\" style=\"clear: both\">12.7.\u00a0\u914d\u7f6e\u793a\u4f8b </h2>\n</div>\n</div>\n</h2>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6307\u5b9a\u4e86\u5c06\u4e00\u4e2a\u6587\u6863\u8f6c\u6362\u6210\u4e00\u4e2a<code class=\"type\">tsvector</code>\u6240\u9700\u7684\u6240\u6709\u9009\u9879\uff1a\u7528\u4e8e\u628a\u6587\u672c\u5206\u89e3\u6210\u8bcd\u5143\u7684\u89e3\u6790\u5668\uff0c\u4ee5\u53ca\u7528\u4e8e\u5c06\u6bcf\u4e00\u4e2a\u8bcd\u5143\u8f6c\u6362\u6210\u8bcd\u4f4d\u7684\u8bcd\u5178\u3002\u6bcf\u4e00\u6b21<code class=\"function\">to_tsvector</code>\u6216<code class=\"function\">to_tsquery</code>\u7684\u8c03\u7528\u90fd\u9700\u8981\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6765\u6267\u884c\u5176\u5904\u7406\u3002\u914d\u7f6e\u53c2\u6570<a class=\"xref\" href=\"/docs/19/runtime-config-client.html#GUC-DEFAULT-TEXT-SEARCH-CONFIG\">default_text_search_config</a>\u6307\u5b9a\u4e86\u9ed8\u8ba4\u914d\u7f6e\u7684\u540d\u79f0\uff0c\u5982\u679c\u7701\u7565\u4e86\u663e\u5f0f\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u6587\u672c\u68c0\u7d22\u51fd\u6570\u5c06\u4f1a\u4f7f\u7528\u5b83\u3002\u5b83\u53ef\u4ee5\u5728<code class=\"filename\">postgresql.conf</code>\u4e2d\u8bbe\u7f6e\uff0c\u6216\u8005\u4f7f\u7528<code class=\"command\">SET</code>\u547d\u4ee4\u4e3a\u4e00\u4e2a\u5355\u72ec\u7684\u4f1a\u8bdd\u8bbe\u7f6e\u3002</p>\n<p lang=\"zh\">\u6709\u4e00\u4e9b\u9884\u5b9a\u4e49\u7684\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u53ef\u7528\uff0c\u5e76\u4e14\u4f60\u53ef\u4ee5\u5bb9\u6613\u5730\u521b\u5efa\u81ea\u5b9a\u4e49\u7684\u914d\u7f6e\u3002\u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e00\u7ec4<acronym class=\"acronym\">SQL</acronym>\u547d\u4ee4\uff0c\u5e76\u4e14\u6709\u591a\u4e2a<span class=\"application\">psql</span>\u547d\u4ee4\u53ef\u4ee5\u663e\u793a\u6709\u5173\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff08<a class=\"xref\" href=\"/docs/19/textsearch-psql.html\" title=\"12.10.\u00a0psql \u652f\u6301\">\u7b2c\u00a012.10\u00a0\u8282</a>\uff09\u7684\u4fe1\u606f\u3002</p>\n<p lang=\"zh\">\u4f5c\u4e3a\u4e00\u4e2a\u793a\u4f8b\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u914d\u7f6e<code class=\"literal\">pg</code>\uff0c\u4ece\u590d\u5236\u5185\u7f6e\u7684<code class=\"literal\">english</code>\u914d\u7f6e\u5f00\u59cb\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH CONFIGURATION public.pg ( COPY = pg_catalog.english );\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5c06\u4f7f\u7528\u4e00\u4e2a PostgreSQL \u76f8\u5173\u7684\u540c\u4e49\u8bcd\u5217\u8868\uff0c\u5e76\u5c06\u5b83\u5b58\u50a8\u5728<code class=\"filename\">$SHAREDIR/tsearch_data/pg_dict.syn</code>\u4e2d\u3002\u6587\u4ef6\u5185\u5bb9\u770b\u8d77\u6765\u50cf\uff1a</p>\n<pre class=\"programlisting\">postgres    pg\npgsql       pg\npostgresql  pg\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5b9a\u4e49\u540c\u4e49\u8bcd\u8bcd\u5178\u5982\u4e0b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY pg_dict (\n    TEMPLATE = synonym,\n    SYNONYMS = pg_dict\n);\n</pre>\n<p lang=\"zh\">\u63a5\u4e0b\u6765\u6211\u4eec\u6ce8\u518c<span class=\"productname\">Ispell</span>\u8bcd\u5178<code class=\"literal\">english_ispell</code>\uff0c\u5b83\u6709\u5176\u81ea\u5df1\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY english_ispell (\n    TEMPLATE = ispell,\n    DictFile = english,\n    AffFile = english,\n    StopWords = english\n);\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u5728\u914d\u7f6e<code class=\"literal\">pg</code>\u4e2d\u5efa\u7acb\u8bcd\u7684\u6620\u5c04\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,\n                      word, hword, hword_part\n    WITH pg_dict, english_ispell, english_stem;\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u9009\u62e9\u4e0d\u7d22\u5f15\u6216\u641c\u7d22\u67d0\u4e9b\u5185\u7f6e\u914d\u7f6e\u786e\u5b9e\u5904\u7406\u7684\u8bcd\u5143\u7c7b\u578b\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    DROP MAPPING FOR email, url, url_path, sfloat, float;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u6211\u4eec\u7684\u914d\u7f6e\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM ts_debug('public.pg', '\nPostgreSQL, the highly scalable, SQL compliant, open source object-relational\ndatabase management system, is now undergoing beta testing of the next\nversion of our software.\n');\n</pre>\n<p lang=\"zh\">\u4e0b\u4e00\u6b65\u662f\u628a\u4f1a\u8bdd\u8bbe\u7f6e\u4e3a\u4f7f\u7528\u8fd9\u4e2a\u65b0\u914d\u7f6e\uff0c\u8be5\u914d\u7f6e\u662f\u5728 <code class=\"literal\">public</code> \u6a21\u5f0f\u4e2d\u521b\u5efa\u7684\uff1a</p>\n<pre class=\"screen\">=&gt; \\dF\n   List of text search configurations\n Schema  | Name | Description\n---------+------+-------------\n public  | pg   |\n\nSET default_text_search_config = 'public.pg';\nSET\n\nSHOW default_text_search_config;\n default_text_search_config\n----------------------------\n public.pg\n</pre>\n</div>", "manual_path": "/docs/19/textsearch-configuration.html", "localization": {"status": "complete", "sources": [{"url": "/docs/19/catalog-pg-amproc.html", "method": "same-major semantic node", "sha256": "2f3186b0cb3f1b6cdfb964d581bdf7719277157a11db7b3a207830efc10fcf6c", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMPROC/p[5]/span[2]/span[0]"]}, {"url": "/docs/19/textsearch-configuration.html", "method": "same-major semantic node", "sha256": "71a0d298d5d8dd1314e07bb887fa3959b09cb79e6628fa1a71e94eb0ed9ca37f", "language": "zh", "matched_nodes": ["#TEXTSEARCH-CONFIGURATION/div[0]", "#TEXTSEARCH-CONFIGURATION/p[11]", "#TEXTSEARCH-CONFIGURATION/p[13]", "#TEXTSEARCH-CONFIGURATION/p[15]", "#TEXTSEARCH-CONFIGURATION/p[17]", "#TEXTSEARCH-CONFIGURATION/p[1]", "#TEXTSEARCH-CONFIGURATION/p[2]", "#TEXTSEARCH-CONFIGURATION/p[3]", "#TEXTSEARCH-CONFIGURATION/p[5]", "#TEXTSEARCH-CONFIGURATION/p[7]", "#TEXTSEARCH-CONFIGURATION/p[9]"]}, {"url": "/docs/19/using-explain.html", "method": "same-major semantic node", "sha256": "7cc78f59bf29afb1811ece53e9d5c572a3f634d66d7422fb8761f19bc6811492", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Text search configuration estonian.", "/versions/19/facts/0/label": "Configuration", "/versions/19/facts/1/label": "Parser", "/versions/19/facts/1/value": "default", "/versions/19/tables/0/title": "Token-to-dictionary mappings", "/versions/19/related/0/label": "default parser", "/versions/19/sections/0/title": "Generated initdb definition", "/versions/19/sections/0/paragraphs/0": "Generated from this release\u2019s Snowball language list and SQL template.", "/versions/19/tables/0/columns/0/label": "Token type", "/versions/19/tables/0/columns/1/label": "Order", "/versions/19/tables/0/columns/2/label": "Dictionary", "/versions/19/tables/0/rows/0/dictionary/text": "simple", "/versions/19/tables/0/rows/1/dictionary/text": "simple", "/versions/19/tables/0/rows/2/dictionary/text": "simple", "/versions/19/tables/0/rows/3/dictionary/text": "simple", "/versions/19/tables/0/rows/4/dictionary/text": "simple", "/versions/19/tables/0/rows/5/dictionary/text": "simple", "/versions/19/tables/0/rows/6/dictionary/text": "simple", "/versions/19/tables/0/rows/7/dictionary/text": "simple", "/versions/19/tables/0/rows/8/dictionary/text": "simple", "/versions/19/tables/0/rows/9/dictionary/text": "simple", "/versions/19/tables/0/rows/10/dictionary/text": "simple", "/versions/19/tables/0/rows/11/dictionary/text": "simple", "/versions/19/tables/0/rows/12/dictionary/text": "simple"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d3e75ef1044d0d887070abfe202210837041c73a0c86ca45b2875cacebfa3b97"}, "comparison_data": {"parser": "default", "mappings": [{"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}]}, "comparison_hash": "334adb6ccf3840b3ae28576d5a95dd2994f0698720fa793f5e5450e4b70d958b", "manual_language": "zh"}, "20": {"facts": [{"label": "\u914d\u7f6e", "value": "estonian"}, {"label": "\u89e3\u6790\u5668", "value": "\u9ed8\u8ba4"}], "tables": [{"key": "mappings", "rows": [{"token": "email", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "url", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "url_path", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "host", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "file", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "version", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "sfloat", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "float", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "int", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "uint", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "numword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "hword_numpart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "numhword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=20", "text": "\u7b80\u5355"}}, {"token": "asciiword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}, {"token": "hword_asciipart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}, {"token": "asciihword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}, {"token": "word", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}, {"token": "hword_part", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}, {"token": "hword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=20", "text": "estonian_stem"}}], "title": "\u8bcd\u5143\u5230\u8bcd\u5178\u7684\u6620\u5c04", "columns": [{"key": "token", "label": "\u8bcd\u5143\u7c7b\u578b"}, {"key": "sequence", "label": "\u987a\u5e8f"}, {"key": "dictionary", "label": "\u8bcd\u5178"}]}], "aliases": [], "related": [{"url": "/wiki/fts/parser-default/?v=20", "label": "\u9ed8\u8ba4\u89e3\u6790\u5668"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "catalog_fingerprint": "398fbb9f262264053c02fbf79f88be0a6770c1473faa6ecd5931d6ec41b8258b", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/textsearch-configuration.html", "path": "textsearch-configuration.html", "label": "PostgreSQL 20 English manual", "sha256": "103fb0b6b1d46249a247532a5687300b13971bf4e52ffa6c3ca1bd71c4427d50", "language": "en", "original_url": "/docs/devel/textsearch-configuration.html"}], "mappings": [{"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}], "sections": [{"code": "/*\n * text search configuration for estonian language\n *\n * Copyright (c) 2007-2026, PostgreSQL Global Development Group\n *\n * src/backend/snowball/snowball.sql.in\n *\n * estonian and certain other macros are replaced for each language;\n * see the Makefile for details.\n *\n * Note: this file is read in single-user -j mode, which means that the\n * command terminator is semicolon-newline-newline; whenever the backend\n * sees that, it stops and executes what it's got.  If you write a lot of\n * statements without empty lines between, they'll all get quoted to you\n * in any error message about one of them, so don't do that.  Also, you\n * cannot write a semicolon immediately followed by an empty line in a\n * string literal (including a function body!) or a multiline comment.\n */\n\nCREATE TEXT SEARCH DICTIONARY estonian_stem\n\t(TEMPLATE = snowball, Language = estonian );\n\nCOMMENT ON TEXT SEARCH DICTIONARY estonian_stem IS 'snowball stemmer for estonian language';\n\nCREATE TEXT SEARCH CONFIGURATION estonian\n\t(PARSER = default);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION estonian IS 'configuration for estonian language';\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n\tFOR email, url, url_path, host, file, version,\n\t    sfloat, float, int, uint,\n\t    numword, hword_numpart, numhword\n\tWITH simple;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR asciiword, hword_asciipart, asciihword\n\tWITH estonian_stem;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR word, hword_part, hword\n\tWITH estonian_stem;", "title": "initdb \u751f\u6210\u7684\u5b9a\u4e49", "paragraphs": ["\u6839\u636e\u6b64\u7248\u672c\u7684 Snowball \u8bed\u8a00\u5217\u8868\u548c SQL \u6a21\u677f\u751f\u6210\u3002"]}], "signature": "", "attributes": {"parser": "default", "configuration": "estonian"}, "description": ["\u5168\u6587\u68c0\u7d22\u914d\u7f6e estonian\u3002"], "manual_html": "<div class=\"sect1\" id=\"TEXTSEARCH-CONFIGURATION\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h2 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h2 class=\"title\" style=\"clear: both\">12.7.\u00a0\u914d\u7f6e\u793a\u4f8b </h2>\n</div>\n</div>\n</h2>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6307\u5b9a\u4e86\u5c06\u4e00\u4e2a\u6587\u6863\u8f6c\u6362\u6210\u4e00\u4e2a<code class=\"type\">tsvector</code>\u6240\u9700\u7684\u6240\u6709\u9009\u9879\uff1a\u7528\u4e8e\u628a\u6587\u672c\u5206\u89e3\u6210\u8bcd\u5143\u7684\u89e3\u6790\u5668\uff0c\u4ee5\u53ca\u7528\u4e8e\u5c06\u6bcf\u4e00\u4e2a\u8bcd\u5143\u8f6c\u6362\u6210\u8bcd\u4f4d\u7684\u8bcd\u5178\u3002\u6bcf\u4e00\u6b21<code class=\"function\">to_tsvector</code>\u6216<code class=\"function\">to_tsquery</code>\u7684\u8c03\u7528\u90fd\u9700\u8981\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6765\u6267\u884c\u5176\u5904\u7406\u3002\u914d\u7f6e\u53c2\u6570<a class=\"xref\" href=\"/docs/devel/runtime-config-client.html#GUC-DEFAULT-TEXT-SEARCH-CONFIG\">default_text_search_config</a>\u6307\u5b9a\u4e86\u9ed8\u8ba4\u914d\u7f6e\u7684\u540d\u79f0\uff0c\u5982\u679c\u7701\u7565\u4e86\u663e\u5f0f\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u6587\u672c\u68c0\u7d22\u51fd\u6570\u5c06\u4f1a\u4f7f\u7528\u5b83\u3002\u5b83\u53ef\u4ee5\u5728<code class=\"filename\">postgresql.conf</code>\u4e2d\u8bbe\u7f6e\uff0c\u6216\u8005\u4f7f\u7528<code class=\"command\">SET</code>\u547d\u4ee4\u4e3a\u4e00\u4e2a\u5355\u72ec\u7684\u4f1a\u8bdd\u8bbe\u7f6e\u3002</p>\n<p lang=\"zh\">\u6709\u4e00\u4e9b\u9884\u5b9a\u4e49\u7684\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u53ef\u7528\uff0c\u5e76\u4e14\u4f60\u53ef\u4ee5\u5bb9\u6613\u5730\u521b\u5efa\u81ea\u5b9a\u4e49\u7684\u914d\u7f6e\u3002\u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e00\u7ec4<acronym class=\"acronym\">SQL</acronym>\u547d\u4ee4\uff0c\u5e76\u4e14\u6709\u591a\u4e2a<span class=\"application\">psql</span>\u547d\u4ee4\u53ef\u4ee5\u663e\u793a\u6709\u5173\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff08<a class=\"xref\" href=\"/docs/devel/textsearch-psql.html\" title=\"12.10.\u00a0psql \u652f\u6301\">\u7b2c\u00a012.10\u00a0\u8282</a>\uff09\u7684\u4fe1\u606f\u3002</p>\n<p lang=\"zh\">\u4f5c\u4e3a\u4e00\u4e2a\u793a\u4f8b\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u914d\u7f6e<code class=\"literal\">pg</code>\uff0c\u4ece\u590d\u5236\u5185\u7f6e\u7684<code class=\"literal\">english</code>\u914d\u7f6e\u5f00\u59cb\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH CONFIGURATION public.pg ( COPY = pg_catalog.english );\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5c06\u4f7f\u7528\u4e00\u4e2a PostgreSQL \u76f8\u5173\u7684\u540c\u4e49\u8bcd\u5217\u8868\uff0c\u5e76\u5c06\u5b83\u5b58\u50a8\u5728<code class=\"filename\">$SHAREDIR/tsearch_data/pg_dict.syn</code>\u4e2d\u3002\u6587\u4ef6\u5185\u5bb9\u770b\u8d77\u6765\u50cf\uff1a</p>\n<pre class=\"programlisting\">postgres    pg\npgsql       pg\npostgresql  pg\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5b9a\u4e49\u540c\u4e49\u8bcd\u8bcd\u5178\u5982\u4e0b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY pg_dict (\n    TEMPLATE = synonym,\n    SYNONYMS = pg_dict\n);\n</pre>\n<p lang=\"zh\">\u63a5\u4e0b\u6765\u6211\u4eec\u6ce8\u518c<span class=\"productname\">Ispell</span>\u8bcd\u5178<code class=\"literal\">english_ispell</code>\uff0c\u5b83\u6709\u5176\u81ea\u5df1\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY english_ispell (\n    TEMPLATE = ispell,\n    DictFile = english,\n    AffFile = english,\n    StopWords = english\n);\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u5728\u914d\u7f6e<code class=\"literal\">pg</code>\u4e2d\u5efa\u7acb\u8bcd\u7684\u6620\u5c04\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,\n                      word, hword, hword_part\n    WITH pg_dict, english_ispell, english_stem;\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u9009\u62e9\u4e0d\u7d22\u5f15\u6216\u641c\u7d22\u67d0\u4e9b\u5185\u7f6e\u914d\u7f6e\u786e\u5b9e\u5904\u7406\u7684\u8bcd\u5143\u7c7b\u578b\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    DROP MAPPING FOR email, url, url_path, sfloat, float;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u6211\u4eec\u7684\u914d\u7f6e\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM ts_debug('public.pg', '\nPostgreSQL, the highly scalable, SQL compliant, open source object-relational\ndatabase management system, is now undergoing beta testing of the next\nversion of our software.\n');\n</pre>\n<p lang=\"zh\">\u4e0b\u4e00\u6b65\u662f\u628a\u4f1a\u8bdd\u8bbe\u7f6e\u4e3a\u4f7f\u7528\u8fd9\u4e2a\u65b0\u914d\u7f6e\uff0c\u8be5\u914d\u7f6e\u662f\u5728 <code class=\"literal\">public</code> \u6a21\u5f0f\u4e2d\u521b\u5efa\u7684\uff1a</p>\n<pre class=\"screen\">=&gt; \\dF\n   List of text search configurations\n Schema  | Name | Description\n---------+------+-------------\n public  | pg   |\n\nSET default_text_search_config = 'public.pg';\nSET\n\nSHOW default_text_search_config;\n default_text_search_config\n----------------------------\n public.pg\n</pre>\n</div>", "manual_path": "/docs/devel/textsearch-configuration.html", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/catalog-pg-amproc.html", "method": "same-major semantic node", "sha256": "adca05c5ff2b94562e292f0b81459187e8a41a57ab5781a5f22d721ec40aaa6c", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMPROC/p[5]/span[2]/span[0]"]}, {"url": "/docs/devel/textsearch-configuration.html", "method": "same-major semantic node", "sha256": "2528f707db4fbcbc63f279bceed743d15cc5599564e8882ddee1f19869cc3c3b", "language": "zh", "matched_nodes": ["#TEXTSEARCH-CONFIGURATION/div[0]", "#TEXTSEARCH-CONFIGURATION/p[11]", "#TEXTSEARCH-CONFIGURATION/p[13]", "#TEXTSEARCH-CONFIGURATION/p[15]", "#TEXTSEARCH-CONFIGURATION/p[17]", "#TEXTSEARCH-CONFIGURATION/p[1]", "#TEXTSEARCH-CONFIGURATION/p[2]", "#TEXTSEARCH-CONFIGURATION/p[3]", "#TEXTSEARCH-CONFIGURATION/p[5]", "#TEXTSEARCH-CONFIGURATION/p[7]", "#TEXTSEARCH-CONFIGURATION/p[9]"]}, {"url": "/docs/devel/using-explain.html", "method": "same-major semantic node", "sha256": "2744ee0e88d132c504bf5e102765edaabd393eb12c59294093db6d90b26dd65c", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/summary": "Text search configuration estonian.", "/category": "Configurations", "/versions/20/description/0": "Text search configuration estonian.", "/versions/20/facts/0/label": "Configuration", "/versions/20/facts/1/label": "Parser", "/versions/20/facts/1/value": "default", "/versions/20/tables/0/title": "Token-to-dictionary mappings", "/versions/20/related/0/label": "default parser", "/versions/20/sections/0/title": "Generated initdb definition", "/versions/20/sections/0/paragraphs/0": "Generated from this release\u2019s Snowball language list and SQL template.", "/versions/20/tables/0/columns/0/label": "Token type", "/versions/20/tables/0/columns/1/label": "Order", "/versions/20/tables/0/columns/2/label": "Dictionary", "/versions/20/tables/0/rows/0/dictionary/text": "simple", "/versions/20/tables/0/rows/1/dictionary/text": "simple", "/versions/20/tables/0/rows/2/dictionary/text": "simple", "/versions/20/tables/0/rows/3/dictionary/text": "simple", "/versions/20/tables/0/rows/4/dictionary/text": "simple", "/versions/20/tables/0/rows/5/dictionary/text": "simple", "/versions/20/tables/0/rows/6/dictionary/text": "simple", "/versions/20/tables/0/rows/7/dictionary/text": "simple", "/versions/20/tables/0/rows/8/dictionary/text": "simple", "/versions/20/tables/0/rows/9/dictionary/text": "simple", "/versions/20/tables/0/rows/10/dictionary/text": "simple", "/versions/20/tables/0/rows/11/dictionary/text": "simple", "/versions/20/tables/0/rows/12/dictionary/text": "simple"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f1f12a427e7ab16626ccb3bb7865a82a59ab3aaaba0d0f19fb2dbac74bb725b8"}, "comparison_data": {"parser": "default", "mappings": [{"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}]}, "comparison_hash": "334adb6ccf3840b3ae28576d5a95dd2994f0698720fa793f5e5450e4b70d958b", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u914d\u7f6e", "value": "estonian"}, {"label": "\u89e3\u6790\u5668", "value": "\u9ed8\u8ba4"}], "tables": [{"key": "mappings", "rows": [{"token": "email", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "url", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "url_path", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "host", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "file", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "version", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "sfloat", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "float", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "int", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "uint", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "numword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "hword_numpart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "numhword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-simple/?v=18", "text": "\u7b80\u5355"}}, {"token": "asciiword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword_asciipart", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "asciihword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "word", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword_part", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}, {"token": "hword", "sequence": "1", "dictionary": {"url": "/wiki/fts/dictionary-estonian_stem/?v=18", "text": "estonian_stem"}}], "title": "\u8bcd\u5143\u5230\u8bcd\u5178\u7684\u6620\u5c04", "columns": [{"key": "token", "label": "\u8bcd\u5143\u7c7b\u578b"}, {"key": "sequence", "label": "\u987a\u5e8f"}, {"key": "dictionary", "label": "\u8bcd\u5178"}]}], "aliases": [], "related": [{"url": "/wiki/fts/parser-default/?v=18", "label": "\u9ed8\u8ba4\u89e3\u6790\u5668"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/textsearch-configuration.html", "path": "textsearch-configuration.html", "label": "PostgreSQL 18 English manual", "sha256": "7957c03871a5f267f642ec609b2e3d1404eb000ccdef21ca0d1d8a8616110dc9", "language": "en", "original_url": "/docs/18/textsearch-configuration.html"}], "mappings": [{"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}], "sections": [{"code": "/*\n * text search configuration for estonian language\n *\n * Copyright (c) 2007-2025, PostgreSQL Global Development Group\n *\n * src/backend/snowball/snowball.sql.in\n *\n * estonian and certain other macros are replaced for each language;\n * see the Makefile for details.\n *\n * Note: this file is read in single-user -j mode, which means that the\n * command terminator is semicolon-newline-newline; whenever the backend\n * sees that, it stops and executes what it's got.  If you write a lot of\n * statements without empty lines between, they'll all get quoted to you\n * in any error message about one of them, so don't do that.  Also, you\n * cannot write a semicolon immediately followed by an empty line in a\n * string literal (including a function body!) or a multiline comment.\n */\n\nCREATE TEXT SEARCH DICTIONARY estonian_stem\n\t(TEMPLATE = snowball, Language = estonian );\n\nCOMMENT ON TEXT SEARCH DICTIONARY estonian_stem IS 'snowball stemmer for estonian language';\n\nCREATE TEXT SEARCH CONFIGURATION estonian\n\t(PARSER = default);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION estonian IS 'configuration for estonian language';\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n\tFOR email, url, url_path, host, file, version,\n\t    sfloat, float, int, uint,\n\t    numword, hword_numpart, numhword\n\tWITH simple;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR asciiword, hword_asciipart, asciihword\n\tWITH estonian_stem;\n\nALTER TEXT SEARCH CONFIGURATION estonian ADD MAPPING\n    FOR word, hword_part, hword\n\tWITH estonian_stem;", "title": "initdb \u751f\u6210\u7684\u5b9a\u4e49", "paragraphs": ["\u6839\u636e\u6b64\u7248\u672c\u7684 Snowball \u8bed\u8a00\u5217\u8868\u548c SQL \u6a21\u677f\u751f\u6210\u3002"]}], "signature": "", "attributes": {"parser": "default", "configuration": "estonian"}, "description": ["\u5168\u6587\u68c0\u7d22\u914d\u7f6e estonian\u3002"], "manual_html": "<div class=\"sect1\" id=\"TEXTSEARCH-CONFIGURATION\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h2 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h2 class=\"title\" style=\"clear: both\">12.7.\u00a0\u914d\u7f6e\u793a\u4f8b </h2>\n</div>\n</div>\n</h2>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6307\u5b9a\u4e86\u5c06\u4e00\u4e2a\u6587\u6863\u8f6c\u6362\u6210\u4e00\u4e2a<code class=\"type\">tsvector</code>\u6240\u9700\u7684\u6240\u6709\u9009\u9879\uff1a\u7528\u4e8e\u628a\u6587\u672c\u5206\u89e3\u6210\u8bcd\u5143\u7684\u89e3\u6790\u5668\uff0c\u4ee5\u53ca\u7528\u4e8e\u5c06\u6bcf\u4e00\u4e2a\u8bcd\u5143\u8f6c\u6362\u6210\u8bcd\u4f4d\u7684\u8bcd\u5178\u3002\u6bcf\u4e00\u6b21<code class=\"function\">to_tsvector</code>\u6216<code class=\"function\">to_tsquery</code>\u7684\u8c03\u7528\u90fd\u9700\u8981\u4e00\u4e2a\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u6765\u6267\u884c\u5176\u5904\u7406\u3002\u914d\u7f6e\u53c2\u6570<a class=\"xref\" href=\"/docs/18/runtime-config-client.html#GUC-DEFAULT-TEXT-SEARCH-CONFIG\">default_text_search_config</a>\u6307\u5b9a\u4e86\u9ed8\u8ba4\u914d\u7f6e\u7684\u540d\u79f0\uff0c\u5982\u679c\u7701\u7565\u4e86\u663e\u5f0f\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u6587\u672c\u68c0\u7d22\u51fd\u6570\u5c06\u4f1a\u4f7f\u7528\u5b83\u3002\u5b83\u53ef\u4ee5\u5728<code class=\"filename\">postgresql.conf</code>\u4e2d\u8bbe\u7f6e\uff0c\u6216\u8005\u4f7f\u7528<code class=\"command\">SET</code>\u547d\u4ee4\u4e3a\u4e00\u4e2a\u5355\u72ec\u7684\u4f1a\u8bdd\u8bbe\u7f6e\u3002</p>\n<p lang=\"zh\">\u6709\u4e00\u4e9b\u9884\u5b9a\u4e49\u7684\u6587\u672c\u68c0\u7d22\u914d\u7f6e\u53ef\u7528\uff0c\u5e76\u4e14\u4f60\u53ef\u4ee5\u5bb9\u6613\u5730\u521b\u5efa\u81ea\u5b9a\u4e49\u7684\u914d\u7f6e\u3002\u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e00\u7ec4<acronym class=\"acronym\">SQL</acronym>\u547d\u4ee4\uff0c\u5e76\u4e14\u6709\u591a\u4e2a<span class=\"application\">psql</span>\u547d\u4ee4\u53ef\u4ee5\u663e\u793a\u6709\u5173\u6587\u672c\u68c0\u7d22\u5bf9\u8c61\uff08<a class=\"xref\" href=\"/docs/18/textsearch-psql.html\" title=\"12.10.\u00a0psql \u652f\u6301\">\u7b2c\u00a012.10\u00a0\u8282</a>\uff09\u7684\u4fe1\u606f\u3002</p>\n<p lang=\"zh\">\u4f5c\u4e3a\u4e00\u4e2a\u793a\u4f8b\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u914d\u7f6e<code class=\"literal\">pg</code>\uff0c\u4ece\u590d\u5236\u5185\u7f6e\u7684<code class=\"literal\">english</code>\u914d\u7f6e\u5f00\u59cb\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH CONFIGURATION public.pg ( COPY = pg_catalog.english );\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5c06\u4f7f\u7528\u4e00\u4e2a PostgreSQL \u76f8\u5173\u7684\u540c\u4e49\u8bcd\u5217\u8868\uff0c\u5e76\u5c06\u5b83\u5b58\u50a8\u5728<code class=\"filename\">$SHAREDIR/tsearch_data/pg_dict.syn</code>\u4e2d\u3002\u6587\u4ef6\u5185\u5bb9\u770b\u8d77\u6765\u50cf\uff1a</p>\n<pre class=\"programlisting\">postgres    pg\npgsql       pg\npostgresql  pg\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u5b9a\u4e49\u540c\u4e49\u8bcd\u8bcd\u5178\u5982\u4e0b\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY pg_dict (\n    TEMPLATE = synonym,\n    SYNONYMS = pg_dict\n);\n</pre>\n<p lang=\"zh\">\u63a5\u4e0b\u6765\u6211\u4eec\u6ce8\u518c<span class=\"productname\">Ispell</span>\u8bcd\u5178<code class=\"literal\">english_ispell</code>\uff0c\u5b83\u6709\u5176\u81ea\u5df1\u7684\u914d\u7f6e\u6587\u4ef6\uff1a</p>\n<pre class=\"programlisting\">CREATE TEXT SEARCH DICTIONARY english_ispell (\n    TEMPLATE = ispell,\n    DictFile = english,\n    AffFile = english,\n    StopWords = english\n);\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u5728\u914d\u7f6e<code class=\"literal\">pg</code>\u4e2d\u5efa\u7acb\u8bcd\u7684\u6620\u5c04\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,\n                      word, hword, hword_part\n    WITH pg_dict, english_ispell, english_stem;\n</pre>\n<p lang=\"zh\">\u6211\u4eec\u9009\u62e9\u4e0d\u7d22\u5f15\u6216\u641c\u7d22\u67d0\u4e9b\u5185\u7f6e\u914d\u7f6e\u786e\u5b9e\u5904\u7406\u7684\u8bcd\u5143\u7c7b\u578b\uff1a</p>\n<pre class=\"programlisting\">ALTER TEXT SEARCH CONFIGURATION pg\n    DROP MAPPING FOR email, url, url_path, sfloat, float;\n</pre>\n<p lang=\"zh\">\u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6d4b\u8bd5\u6211\u4eec\u7684\u914d\u7f6e\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM ts_debug('public.pg', '\nPostgreSQL, the highly scalable, SQL compliant, open source object-relational\ndatabase management system, is now undergoing beta testing of the next\nversion of our software.\n');\n</pre>\n<p lang=\"zh\">\u4e0b\u4e00\u6b65\u662f\u628a\u4f1a\u8bdd\u8bbe\u7f6e\u4e3a\u4f7f\u7528\u8fd9\u4e2a\u65b0\u914d\u7f6e\uff0c\u8be5\u914d\u7f6e\u662f\u5728 <code class=\"literal\">public</code> \u6a21\u5f0f\u4e2d\u521b\u5efa\u7684\uff1a</p>\n<pre class=\"screen\">=&gt; \\dF\n   List of text search configurations\n Schema  | Name | Description\n---------+------+-------------\n public  | pg   |\n\nSET default_text_search_config = 'public.pg';\nSET\n\nSHOW default_text_search_config;\n default_text_search_config\n----------------------------\n public.pg\n</pre>\n</div>", "manual_path": "/docs/18/textsearch-configuration.html", "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-amproc.html", "method": "same-major semantic node", "sha256": "c1b7d16e812991b4d5fb68085a27c8ff82aeaffa34afda56c5837f9b7588187c", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMPROC/p[5]/span[2]/span[0]"]}, {"url": "/docs/18/textsearch-configuration.html", "method": "same-major semantic node", "sha256": "7f803d5b93ebfbc7277584f660e479e20eda950c121e0bb8a1e3ecd81268870c", "language": "zh", "matched_nodes": ["#TEXTSEARCH-CONFIGURATION/div[0]", "#TEXTSEARCH-CONFIGURATION/p[11]", "#TEXTSEARCH-CONFIGURATION/p[13]", "#TEXTSEARCH-CONFIGURATION/p[15]", "#TEXTSEARCH-CONFIGURATION/p[17]", "#TEXTSEARCH-CONFIGURATION/p[1]", "#TEXTSEARCH-CONFIGURATION/p[2]", "#TEXTSEARCH-CONFIGURATION/p[3]", "#TEXTSEARCH-CONFIGURATION/p[5]", "#TEXTSEARCH-CONFIGURATION/p[7]", "#TEXTSEARCH-CONFIGURATION/p[9]"]}, {"url": "/docs/18/using-explain.html", "method": "same-major semantic node", "sha256": "b8835ec9adbc70ec150667a6b5443f8d298222dc0cc8c2bd1abb1c1d64895904", "language": "zh", "matched_nodes": ["#USING-EXPLAIN/div[7]/p[24]/span[0]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Text search configuration estonian.", "/versions/18/facts/0/label": "Configuration", "/versions/18/facts/1/label": "Parser", "/versions/18/facts/1/value": "default", "/versions/18/tables/0/title": "Token-to-dictionary mappings", "/versions/18/related/0/label": "default parser", "/versions/18/sections/0/title": "Generated initdb definition", "/versions/18/sections/0/paragraphs/0": "Generated from this release\u2019s Snowball language list and SQL template.", "/versions/18/tables/0/columns/0/label": "Token type", "/versions/18/tables/0/columns/1/label": "Order", "/versions/18/tables/0/columns/2/label": "Dictionary", "/versions/18/tables/0/rows/0/dictionary/text": "simple", "/versions/18/tables/0/rows/1/dictionary/text": "simple", "/versions/18/tables/0/rows/2/dictionary/text": "simple", "/versions/18/tables/0/rows/3/dictionary/text": "simple", "/versions/18/tables/0/rows/4/dictionary/text": "simple", "/versions/18/tables/0/rows/5/dictionary/text": "simple", "/versions/18/tables/0/rows/6/dictionary/text": "simple", "/versions/18/tables/0/rows/7/dictionary/text": "simple", "/versions/18/tables/0/rows/8/dictionary/text": "simple", "/versions/18/tables/0/rows/9/dictionary/text": "simple", "/versions/18/tables/0/rows/10/dictionary/text": "simple", "/versions/18/tables/0/rows/11/dictionary/text": "simple", "/versions/18/tables/0/rows/12/dictionary/text": "simple"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e802d122036da026cc651d51a639619c337cf6f5b57242243f2f1cfb576c14a8"}, "comparison_data": {"parser": "default", "mappings": [{"token": "asciihword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "asciiword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "email", "sequence": "1", "dictionary": "simple"}, {"token": "file", "sequence": "1", "dictionary": "simple"}, {"token": "float", "sequence": "1", "dictionary": "simple"}, {"token": "host", "sequence": "1", "dictionary": "simple"}, {"token": "hword", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_asciipart", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "hword_numpart", "sequence": "1", "dictionary": "simple"}, {"token": "hword_part", "sequence": "1", "dictionary": "estonian_stem"}, {"token": "int", "sequence": "1", "dictionary": "simple"}, {"token": "numhword", "sequence": "1", "dictionary": "simple"}, {"token": "numword", "sequence": "1", "dictionary": "simple"}, {"token": "sfloat", "sequence": "1", "dictionary": "simple"}, {"token": "uint", "sequence": "1", "dictionary": "simple"}, {"token": "url", "sequence": "1", "dictionary": "simple"}, {"token": "url_path", "sequence": "1", "dictionary": "simple"}, {"token": "version", "sequence": "1", "dictionary": "simple"}, {"token": "word", "sequence": "1", "dictionary": "estonian_stem"}]}, "comparison_hash": "334adb6ccf3840b3ae28576d5a95dd2994f0698720fa793f5e5450e4b70d958b", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,100 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"mappings\": [\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"asciihword\"\n+    },\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"asciiword\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"email\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"file\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"float\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"host\"\n+    },\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"hword\"\n+    },\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"hword_asciipart\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"hword_numpart\"\n+    },\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"hword_part\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"int\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"numhword\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"numword\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"sfloat\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"uint\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"url\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"url_path\"\n+    },\n+    {\n+      \"dictionary\": \"simple\",\n+      \"sequence\": \"1\",\n+      \"token\": \"version\"\n+    },\n+    {\n+      \"dictionary\": \"estonian_stem\",\n+      \"sequence\": \"1\",\n+      \"token\": \"word\"\n+    }\n+  ],\n+  \"parser\": \"default\"\n+}"}}