WG: another newbees question to postgres and pictures
От | Horst.Baumeister@infineon.com |
---|---|
Тема | WG: another newbees question to postgres and pictures |
Дата | |
Msg-id | 7112D14A8761D11191720001FA7EA04C02CE77CE@mchb0f8a.muc.infineon.com обсуждение исходный текст |
Список | pgsql-novice |
> -----Ursprüngliche Nachricht----- > Von: Baumeister Horst (CPR PH) > Gesendet am: Donnerstag, 17. August 2000 21:14 > An: 'pgsql-questions@postgreSQL.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@id.jefferson.co.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 thesyntax. > 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 somethinglike 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.Baumeister@infineon.de > > <<Baumeister Horst (CPR PH).vcf>> > > ____________________________________________________________________________________________________________________________ > Re: JPEG Files In Postgres Database > > > > From: sobrien@id.jefferson.co.us () > To: pgsql-questions@postgreSQL.org > Subject: Re: JPEG Files In Postgres Database > Date: 26 Apr 1999 19:12:07 GMT > > > > Rick Bourassa (rickb@networxtech.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
Вложения
В списке pgsql-novice по дате отправления: