Last edit
Changed:
< Note: [http://tsearch2api.projects.postgresql.org/ tsearch2api]] -
to
> Note: [http://tsearch2api.projects.postgresql.org/ tsearch2api] -
Added:
> Read [http://sql-info.de/postgresql/notes/converting-tsearch2-to-8.3.html Converting tsearch2 to 8.3] by Ian Barwick
Note: tsearch2api - Binary compatible tsearch2 API for PostgreSQL.
Read Converting tsearch2 to 8.3 by Ian Barwick
Use \h command in psql to show syntax of text search related SQL commands:
\h create text search \h alter text search \h drop text search
event=# CREATE TEXT SEARCH DICTIONARY en_ispell ( TEMPLATE = ispell, DictFile = english, AffFile = english, StopWords = english );
CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config )
event=# CREATE TEXT SEARCH CONFIGURATION public.pg ( COPY = english );