Re: pg_lo_import alternative ... - Mailing list pgsql-admin

From Kent L. Nasveschuk
Subject Re: pg_lo_import alternative ...
Date
Msg-id 1070109152.2065.64.camel@1134
Whole thread Raw
In response to Re: pg_lo_import alternative ...  ("Rudi Starcevic" <rudi@oasis.net.au>)
List pgsql-admin
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@wareham.k12.ma.us>


pgsql-admin by date:

Previous
From: ow
Date:
Subject: Why both?: /var/log/messages AND /var/log/pgsql.
Next
From: ow
Date:
Subject: Re: Why both?: /var/log/messages AND /var/log/pgsql.