PostgreSQL Newbies - Searching docs (.doc .pdf .xls .txt) stored in a PGSQL database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Searching docs (.doc .pdf .xls .txt) stored in a PGSQL database

liam.friel@gmail.com

2005-07-09, 9:23 am

Hi,

not too certain if this is the right group, but this seems like a very
basic question to which I do not know the answer.

We have a website with a PGSQL backend. Provides various project
management services over the web.

One of the things that users can do is post documents to their
projects. These documents are stored in the database itself (PHP
base64_encoded). Any type of document can be uploaded, with the common
ones being .PDF, MS Word, Excel, plain text)

Is there some obvious way that I can allow searching of these document
contents?

Any hints gratefully accepted.

Liam

Sponsored Links