Re: [SQL] Searching Text Fields - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] Searching Text Fields
Date
Msg-id 199906120106.VAA26406@candle.pha.pa.us
Whole thread Raw
In response to Searching Text Fields  (Henrik Steffen <webmaster@city-map.de>)
List pgsql-sql
See contrib/fulltextindex


> Hi all,
> 
> I need a way to search for a keyword that may appear as a substring in
> any field of any table.
> 
> There are 10 tables with 5 to 15 fields, most of them text and char
> fields, several thousand records.
> 
> How can I do it efficiently?
> 
> Can anyone point me to some useful information or show me an example?
> 
> 
> Thanks in advance
> 
> 
> Kind regards,
> 
> 
> Henrik Steffen
> city-map Stade
> http://www.Stade.net
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Mail for error in tuples
Next
From: Alexander Schneider
Date:
Subject: Full-Text-Indexing