Re: JPEG Files In Postgres Database

Rick Bourassa (rickb(at)networxtech(dot)com) wrote:
: Can anyone tell me how to store jpeg fies in a Postgres table? What field
: type to use?

: I am doing some develpment with VB and ODBC.

Rick: I have had really good luck with the following:

create table pix (sch char(6), picture oid) archive=none;
grant select on pix to public;
insert into pix (sch, picture)
values ('001', lo_import('/home/sobrien/pix/knight.jpg'));
insert into pix (sch, picture)
values ('002', lo_import('/home/sobrien/pix/parrot.jpg'));
insert into pix (sch, picture)
values ('003', lo_import('/home/sobrien/pix/penguin.jpg'));
insert into pix (sch, picture)
values ('004', lo_import('/home/sobrien/pix/raccoon.jpg'));
insert into pix (sch, picture)
values ('005', lo_import('/home/sobrien/pix/rose.jpg'));
insert into pix (sch, picture)
values ('006', lo_import('/home/sobrien/pix/rundog.jpg'));
insert into pix (sch, picture)
values ('007', lo_import('/home/sobrien/pix/snail.jpg'));
insert into pix (sch, picture)
values ('008', lo_import('/home/sobrien/pix/spider.jpg'));
insert into pix (sch, picture)
values ('009', lo_import('/home/sobrien/pix/stork.jpg'));
insert into pix (sch, picture)
values ('010', lo_import('/home/sobrien/pix/tulip.jpg'));

Good Luck,
Steve