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().
For example:
create table graphics
(name text, graphic oid);
insert into graphics values ('pic1', lo_import ('gif1.gif'));
Check out the manpage for large_objects for more info.
BTW, does anyone know, once I create a large object, and it creates the
files xinv... and xinx..., how I can get rid of postgres's references to
these objects when I no longer need them. (vacuum gives a notice that it
can't remove these even if I have physically removed the files from the
database's directory).
-Matt
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
>
> -----------------------------------------------------------------------
> 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.
>
>
>
>
>