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

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(at)Dionysia(dot)org www.LouisvilleTimes.org
> www.Dionysia.org/~dionysos/ Dionysia Design
> ICQ Number: 8171285 www.Dionysia.com/design/
> -----------------------------------------------------------------------
> I doubt, therefore I might be.
>
>
>
>
>