 "tsearch2.sql" holds all the wonderful little goodies
you need to do full text indexing. It defines numerous functions
and operators, and creates the needed tables in the database. There
will be 4 new tables created after running the tsearch2.sql file :
pg_ts_dict, pg_ts_parser, pg_ts_cfg, pg_ts_cfgmap are added.</p>
<p>You can check out the tables if you like:</p>
<pre>
        #psql ftstest
        ftstest=# \d
                    List of relations
         Schema |     Name     | Type  |  Owner
        