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.

Post new comment
Got something to add - just enter a comment
all other fields are optional.