Re: [GENERAL] [SQL] Can I store bitmap graphics in a table?

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Matt McClure <matthew(dot)mcclure(at)yale(dot)edu>
Cc: Dan Delaney <dionysos(at)dionysia(dot)org>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] [SQL] Can I store bitmap graphics in a table?
Date: 1998-07-25 13:08:23
Message-ID: Pine.LNX.3.96.980725140629.3383G-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 21 Jul 1998, Matt McClure wrote:

> I'm relatively new to postgres myself, but I'll take a stab at this.
> Anyone can feel free to correct me if I'm wrong.
>
> You can insert the graphic file by declaring the type to be OID and using
> lo_import().

The down side to lo_import is that the file has to be on the server.
There are ways of doing this from the client. An example for libpq is in
the source tree (I can't remember where exactly), and the ImageViewer and
BlobTest examples in the jdbc directory also show this.

> On Tue, 21 Jul 1998, Dan Delaney wrote:
>
> > Hello all,
> > Can a bitmap graphic file (say a GIF, JPEG, or EPS) be stored
> > into a PostgreSQL table? If so, how? What field type should I set up
> > in the table and how do I insert the graphic file?
> > Thanks.
> > --Dan

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk

In response to

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1998-07-26 03:00:00 Weekly Posting: Mini-FAQ (Last Modified: Jun 7, 98)
Previous Message Peter T Mount 1998-07-25 13:05:10 Re: [GENERAL] Can I store bitmap graphics in a table?