Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can I store bitmap graphics in a table?

Can I store bitmap graphics in a table?

From
Dan Delaney
Date:
Hello all, can a bitmap graphic file be stored into a table? If so,
how? What field type should I set up in the table and how do I
insert the graphic file?
   Thanks.
 --Dan

-----------------------------------------------------------------------
 Daniel G. Delaney                    The Louisville Times Chorus
 Dionysos@Dionysia.org                   www.LouisvilleTimes.org
 www.Dionysia.org/~dionysos/          Dionysia Design
 ICQ Number: 8171285                     www.Dionysia.com/design/
-----------------------------------------------------------------------
                   I doubt, therefore I might be.

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

From
Peter T Mount
Date:
On Mon, 20 Jul 1998, Dan Delaney wrote:

> Hello all, can a bitmap graphic file be stored into a table? If so,
> how? What field type should I set up in the table and how do I
> insert the graphic file?
>    Thanks.
>  --Dan

You need to use large objects.

Currently you use the oid type to store a large object's oid in a table.
Then using the lo_ functions to store and retrieve the image.

The easiest thing to do is look at the docs, although you may want to look
at the ImageViewer example in the JDBC driver (src/interfaces/jdbc/examples)
as it does this exact thing.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.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@maidstone.gov.uk