The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards.|
You should construct the string literal in some scripting language - don't forget to quote it.
|Specific to PostgreSQL|
|The LIKE command is case sensitive - to do a case insensitive search you should force the searched field and the search term into lower (or upper) case. Without this we would miss "Bahamas, The"|