| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Mike <akiany(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to search? |
| Date: | 2006-01-05 07:37:28 |
| Message-ID: | 20060105073728.GB17322@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 02, 2006 at 11:21:40 -0800,
Mike <akiany(at)gmail(dot)com> wrote:
> I am new in this field and would appreciate it if someone points me to
> the right direction.
>
> I have a website with lots of users and each have lots of data in
> multiple tables. I want to create a search box where a user can search
> between all their data for the match. I want to search system to
> contain multiple words and be forgiving. How do I do it? Do I have to
> create a flat text of every record in my tables and then run the search
>
> through them for every word entered? That doesn't sound right? It would
>
> exhaust my database with a few users...
You probably want to look at tsearch2.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2006-01-05 08:47:32 | Re: pg admin III and primary keys (for backup/restore) |
| Previous Message | Klint Gore | 2006-01-05 07:35:10 | Re: Putting restrictions on pg_dump? |