what is the best way of storing text+image documents in postgresql

From: Arash pajoohande <apajoohande(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: what is the best way of storing text+image documents in postgresql
Date: 2011-06-08 10:13:16
Message-ID: BANLkTi=7e1W9V-srhX1HcNa6=2zzrH8k0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello
i have a lot of files in microsoft word format. each file consists of text
and images (other text formatting like font is not important).
i want to store this documents in Postgresql, and documents must display on
web page when corresponding user requests occurs.

it seems theres 2 way to do that:
1. save .doc documents in bytea columns. and show them with a word reader in
web page (disadvantage: it needs a proper .doc reader installed on user
computer)
2. convert document to html format and store html code as string
(disadvantage: images will remain in file system)

what is your offer? any help highly would be appreciated

thanks in advance
arash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-06-08 10:24:40 Re: Recurring events
Previous Message Leonardo Francalanci 2011-06-08 09:54:57 Re: Postgres or Greenplum