WG: another newbees question to postgres and pictures

> -----Ursprüngliche Nachricht-----
> Von: Baumeister Horst (CPR PH)
> Gesendet am: Donnerstag, 17. August 2000 21:14
> An: 'pgsql-questions(at)postgreSQL(dot)org'
> Betreff: WG: another newbees question to postgres and pictures
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Baumeister Horst (CPR PH)
> Gesendet am: Donnerstag, 17. August 2000 21:05
> An: 'sobrien(at)id(dot)jefferson(dot)co(dot)us'
> Betreff: another newbees question to postgres and pictures
>
> Hello everybody,
>
> to day I had the same question than Rick had one year ago. However, I found Steves mail to Rick (see below) and tried the syntax.
> The first command "create table ...... ) archive=none; generates a parse error.
> If I type the create table .....); without the "archive..." then it works.
>
> (The current version of postgreSQL is displayed as 6.5.3, it is installed on SUSE 6.4, Kernel 2.2.14, gcc 2.95.2)
>
> Thus I inserted a few picturefiles and got results like this: INSERT 19095 1 and so on.
>
> Now, my question:
> How can I access the picture or even get an idea what the real filename is. I think the number after INSERT is something like a vector.
>
> Best regards
>
> Horst
>
> _______________________________________________
> Infineon AG
> CPR PH
> Horst Baumeister
> Otto-Hahn-Ring 6
> 81739 München
> Tel. ++49 89 234-48472
> Fax ++49 89 234 41658
> Mail: Horst(dot)Baumeister(at)infineon(dot)de
> > <<Baumeister Horst (CPR PH).vcf>>
>
> ____________________________________________________________________________________________________________________________
> Re: JPEG Files In Postgres Database
>
>
>
> From: sobrien(at)id(dot)jefferson(dot)co(dot)us ()
> To: pgsql-questions(at)postgreSQL(dot)org
> Subject: Re: JPEG Files In Postgres Database
> Date: 26 Apr 1999 19:12:07 GMT
>
>
>
> 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
>
>
>
>
>
> Prev by Date: Re: [GENERAL] advice on buying sun hardware to run postgres
> Next by Date: Re: [GENERAL] advice on buying sun hardware to run postgres
> Prev by thread: JPEG Files In Postgres Database
> Next by thread: entity relationship diagram free software
> Index(es):
> Date
> Thread
>
> Home | Main Index | Thread Index