From: | "Leo" <fleovey(at)jus(dot)gov(dot)ar> |
---|---|
To: | "Rodrigo E(dot) De León Plicet" <rdeleonp(at)gmail(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Full text indexing of documents |
Date: | 2008-02-19 14:34:20 |
Message-ID: | 000601c87304$84de3e40$232401c8@leo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Feb 18, 2008 10:08 AM, Leo <fleovey(at)jus(dot)gov(dot)ar> wrote:
> How can I create the tsvector data for large text files WITHOUT
loading the
> text into a column of the DB?
> I did it using 2 tables (one with the text inserted with a perl
program) and
> copying the tsvectors and removing the table with the text, but it is
not
> easy to add data this way.
> The text files are "frozen" HTML documents so I don't need a trigger
to
> 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 special
data
> 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-GENFILEThis is exactly whay I was looking for! Many thanks to Rodrigo
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Cocks | 2008-02-20 02:30:29 | Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP |
Previous Message | Steve T | 2008-02-19 07:23:18 | Re: SQL question |