目录

pg_ts_parser

定义全文搜索解析器的系统表

pg_ts_parser 是一个 系统目录 表，用于定义 全文搜索 解析器。

pg_ts_parser 在 PostgreSQL 8.3 中添加。

按 PostgreSQL 版本定义

pg_ts_parser (PostgreSQL 19)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 18)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 17)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 16)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 15)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 14)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE CONSTRAINT, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 13)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 12)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null | 
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 11)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 10)

             Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 prsname      | name    |           | not null | 
 prsnamespace | oid     |           | not null | 
 prsstart     | regproc |           | not null | 
 prstoken     | regproc |           | not null | 
 prsend       | regproc |           | not null | 
 prsheadline  | regproc |           | not null | 
 prslextype   | regproc |           | not null | 
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.6)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.5)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.4)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.3)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.2)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.1)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 9.0)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 8.4)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

pg_ts_parser (PostgreSQL 8.3)

  Table "pg_catalog.pg_ts_parser"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 prsname      | name    | not null
 prsnamespace | oid     | not null
 prsstart     | regproc | not null
 prstoken     | regproc | not null
 prsend       | regproc | not null
 prsheadline  | regproc | not null
 prslextype   | regproc | not null
Indexes:
    "pg_ts_parser_oid_index" UNIQUE, btree (oid)
    "pg_ts_parser_prsname_index" UNIQUE, btree (prsname, prsnamespace)

文档: pg_ts_parser

变更历史

自 PostgreSQL 8.3 添加以来，此表未被修改。

示例

pg_ts_parser 的典型内容

postgres=# SELECT * from pg_ts_parser\gx
-[ RECORD 1 ]+---------------
oid          | 3722
prsname      | default
prsnamespace | 11
prsstart     | prsd_start
prstoken     | prsd_nexttoken
prsend       | prsd_end
prsheadline  | prsd_headline
prslextype   | prsd_lextype

分类

全文搜索, 系统目录

另请参阅

pg_ts_parser_is_visible(), pg_ts_config, pg_ts_config_map, pg_ts_dict, pg_ts_template

反馈

提交关于“pg_ts_parser”的任何评论、建议或更正，请点击 此处。