storing files in postgres

From: "Bob Powell" <bob(at)hotchkiss(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: storing files in postgres
Date: 2005-03-31 17:03:30
Message-ID: s24be720.093@grpwise.hotchkiss.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Bob Powell
Database Administrator

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph M. Day 2005-03-31 17:16:29 Re: Temporary Tables
Previous Message Patrick.FICHE 2005-03-31 16:45:26 Re: Temporary Tables