Re: Full text indexing of documents - Mailing list pgsql-novice

From Leo
Subject Re: Full text indexing of documents
Date
Msg-id 000601c87304$84de3e40$232401c8@leo
Whole thread Raw
In response to Full text indexing of documents  ("Leo" <fleovey@jus.gov.ar>)
List pgsql-novice
On Feb 18, 2008 10:08 AM, Leo <fleovey@jus.gov.ar> wrote:
> How can I create the tsvector data for large text files WITHOUTloading the
> text into a column of the DB?
> I did it using 2 tables (one with the text inserted with a perlprogram) and
> copying the tsvectors and removing the table with the text, but it isnot
> easy to add data this way.
> The text files are "frozen" HTML documents so I don't need a triggerto
> update the tsvector, all I store is a URL of the text.
> So what I need  is a way to point to a file (maybe there is a specialdata
> type?) and create the tsvector from the document.

Try using pg_read_file() to see if it helps you:
http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNCTIONS-ADMIN-GENFILE
This is exactly whay I was looking for!  Many thanks to Rodrigo

pgsql-novice by date:

Previous
From: Steve T
Date:
Subject: Re: SQL question
Next
From: "Greg Cocks"
Date:
Subject: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP