what is the best way of storing text+image documents in postgresql - Mailing list pgsql-general

From Arash pajoohande
Subject what is the best way of storing text+image documents in postgresql
Date
Msg-id BANLkTi=7e1W9V-srhX1HcNa6=2zzrH8k0A@mail.gmail.com
Whole thread Raw
Responses Re: what is the best way of storing text+image documents in postgresql
Re: what is the best way of storing text+image documents in postgresql
Re: what is the best way of storing text+image documents in postgresql
List 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

pgsql-general by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: Postgres or Greenplum
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Recurring events