PracticalWeb Ltd

Websites that work for you.

Full Text Searching on PostgreSQL With Tsearch2

I’ve just been experimenting with text searches:

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 pg_ts_)

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.