| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Gralewski Daniel <ddutra_br(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tsearch2 and bytea |
| Date: | 2004-04-26 18:26:16 |
| Message-ID: | 20040426182616.GC1580@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 20, 2004 at 02:32:07PM -0700, Gralewski Daniel wrote:
> Does tsearch2 support indexing on bytea column?
>
> I'll have a table where i'll put any kind of file:
> xml, txt, pdf, gif, jpg. And i would like textual
> search on it.
As long as you can come up with text for the files ... what use would be
indexing a PDF, which is mostly compressed information? Or a JPEG file,
which is only a stream of bits? You could of course write some
descriptive keywords for images, or extract the whole text from the PDF
with some tool, and index that.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-04-26 18:36:04 | Re: Postgres DB |
| Previous Message | Andrew Sullivan | 2004-04-26 18:23:36 | Re: Replication |