Search all columns in Postgresql table
Posted on 2012-04-04
I am looking for a way to allow a user from a web front end to query all columns in a postgresql table for multiple values. So if had a tabled named Orders that has columns "id, date, customer, product".
I would like allow the user to be able to search for all entries in the table where the customer Bill ordered lamps by passing a search value of "Bill + Lamps" or something similar to this.
I'm thinking I will need to setup full-text search, but I wasn't sure if this is the case and how to set it up.