Skip site navigation (1) Skip section navigation (2)

WG: another newbees question to postgres and pictures

From: Horst(dot)Baumeister(at)infineon(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: WG: another newbees question to postgres and pictures
Date: 2000-08-17 19:19:03
Message-ID: 7112D14A8761D11191720001FA7EA04C02CE77CE@mchb0f8a.muc.infineon.com (view raw or flat)
Thread:
Lists: pgsql-novice

> -----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 

Attachment: Baumeister Horst (CPR PH).vcf
Description: application/octet-stream (272 bytes)

pgsql-novice by date

Next:From: Poul L. ChristiansenDate: 2000-08-17 20:07:33
Subject: Re: pg_hba.conf file
Previous:From: Robinson, Marlena CECOM RDEC I2WDDate: 2000-08-17 17:38:24
Subject: FW: pg_hba.conf file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group