On Mon, Jun 12, 2006 at 02:44:34PM -0700, jdwatson1@xxxxxxxxx wrote: > 1. How can I store the word doc's in the DB, would it be best to use a > BLOB data type? Use a bytea field. > 2. Does Postgres support full text searching of a word document once it Nope. > is loaded into the BLOB column & how would this work? Would I have to > unload each BLOB object, convert it back to text to search, or does > Postgres have the ability to complete the full-text search of a BLOB, > like MSSQL Server & Oracle do? You'd want to store the plain-text version of the doc and then index that using tsearch2. Actually, there may be a way to avoid storing the text representation if you get clever with tsearch2... worst case you might need to extend tsearch2 so you can feed it an arbitrary function instead of a field. > 3. Is there a way to export the Word Doc From the BLOB colum and dump > it into a PDF format (I guess I am asking if someone has seen or > written a PDF generator script/storedProc for Postgres)? No, but you should be able to make that happen using an untrusted language/function and some external tools. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
