Re: pg_lo_import alternative ...

Your method sounds very interesting for storing images. I'd be
interested in knowing what other attributes you store with the images.
My interest in storing images is for documents that pertain to personnel
records such as copy of certifications, licenses, diploma, training
courses, personnel evaluations. Many are scanned images.

create table external_object(
exobid integer not null default
nextval('external_object_seq'::text),
exob OID not null,
useradd_eid integer references employee,
insert_timestamp timestamp,
mod_timestamp timestamp default now(),
mimetype varchar(30) not null default 'jpeg',
description varchar(30) not null,
filename varchar(100) not null,
table_ref varchar(20),
key_id_ref integer,
flags char(2),
doctype_version varchar(4),
constraint external_obj_pk primary key(exobid)
);

When you do backups do you use pg_dump or are you able to shutdown
postgres to use something like rsync?

On Wed, 2003-11-26 at 23:51, Rudi Starcevic wrote:
> Hi,
>
> > Anyone that that is using Postgres for storage and retrival of
> > images please post your experiences.
>
> I've been very happy with a web application I built which stores
> images in Postgresql in text format. I use PHP to base_64 encode
> the binary image file into a text string and store that.
>
> I can send you a PHP class which I use to encode/decode the
> images and inserts them into a table.
> Email me off list if your keen.
>
> Cheers
> Rudi.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
Kent L. Nasveschuk <kent(at)wareham(dot)k12(dot)ma(dot)us>