Practicalweb Ltd

Technical information on this site may be out of date : no updates since 2015

Full text searching on PostgreSQL with tsearch2

August 9 2005 : posted under postgresql sql

I’ve just been experimenting with text searches: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html

It’s worth noting that most of the commands in the above tutorial assume you are running as the database superuser, this is required to run the setup script but then you can grant permission for an ordinary user for the search tables (in the public schema names starting pgts)

The search will only match words that start with the search term, but is very fast and can search over several columns by maintaining a combined index.