Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the FTS Configuration dialog to configure a full text search. A text
search configuration specifies a text search parser that can divide a string
into tokens, along with dictionaries that can identify searchable tokens.
The FTS Configuration dialog organizes the development of a FTS configuration
through the following dialog tabs: “General, Definition, and Tokens. The
SQL tab displays the SQL code generated by dialog selections.
Click the General tab to begin.
Use the fields in the General tab to identify a FTS configuration:
Click the Definition tab to continue.
Use the fields in the Definition tab to define parameters:
Click the Tokens tab to continue.
Use the fields in the Tokens tab to add a token:
Repeat these steps to add additional tokens; to discard a token, click the
trash icon to the left of the row and confirm deletion in the Delete Row
Click the SQL tab to continue.
Your entries in the FTS Configuration dialog generate a SQL command (see an
example below). Use the SQL tab for review; revisit or switch tabs to make
any changes to the SQL command.
The following is an example of the sql command generated by user selections in
the FTS Configuration dialog:
The example shown demonstrates creating a FTS configuration named
meme_phrases. It uses the default parser.