Tsearch2 README File Example: In More Detail (Continued)

Install Tsearch2 into a database.

psql ts_db < /usr/local/pgsql/lib/contrib/tsearch2.sql;

This installs the following into a database:

• Tables
  • pg_ts_cfg
  • pg_ts_cfgmap
  • pg_ts_dict
  • pg_ts_parser
• Functions
  • to_tsvector
  • to_tsquery
  • rank
  • headline
  • stat
  • tsearch2
  • ...
• Types
  • tsvector
  • tsquery
  • ...
• Operators
  • @@
  • ||