Received: from cloud.ndh.net (cloud.ndh.net [195.94.94.16]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA23722 for ; Fri, 11 Jun 1999 14:18:55 -0400 (EDT) (envelope-from webmaster@city-map.de) Received: from r-124.hamburg.ipdial.viaginterkom.de ([62.180.35.124] helo=city-map.de) by cloud.ndh.net with esmtp (Exim 2.05 #1) id 10sV5J-0002H7-00 for pgsql-sql@postgreSQL.org; Fri, 11 Jun 1999 19:27:17 +0200 Message-ID: <376152B8.A2FAFD4A@city-map.de> Date: Fri, 11 Jun 1999 20:17:28 +0200 From: Henrik Steffen Reply-To: henrik@steffen.stade.net Organization: city-map X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Searching Text Fields Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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