storing files in postgres

Hello everyone,

 

I have created a table as follows:

 

CREATE TABLE document (

image_id int,

image bytea

);

 

I want to insert a complete file, let's say an open office document into this table.  Anyone know how I would doe this?

 

Then if I can get the document into the image field, how would I retrieve it to display it in my HTML document?  

 

Thanks in advance.