Re: Load Image File From PostgreSQL DB - Mailing list pgsql-general

From dbalinglung
Subject Re: Load Image File From PostgreSQL DB
Date
Msg-id 047129C969DB45718F9BFFEDFF1D9E45@alam
Whole thread Raw
In response to Load Image File From PostgreSQL DB  ("dbalinglung" <alamsurya@centrin.net.id>)
List pgsql-general

Hi2 Julius,
 
Thanks for your reply, present i using oid data type for store image file, and good working without problem too if i open and showing with PHP, but i'm verry dificulty to showing the image file using delphi 7.
 
also i'm not using third party like ODBC but i'm directly connected to PostgreSQL Database using Zeos Component.
 
Any sugestion for me bro ?
 
many thanks and regards,
 
 
dbalinglung
 
 
>----- Original Message -----
>From: "Julius Tuskenis" <julius.tuskenis@gmail.com>
>Sent: Tuesday, December 30, 2008 2:46 PM
>Subject: Re: [GENERAL] Load Image File From PostgreSQL DB
>
> Hi, dbalinglung.
>
> You are probably confusing types oid and lo or bytea. There's no way you
> could put a image into oid column. I'm using bytea type without problems.
> Also check "bytea as lo" checkbox in ODBC dialog (if you use ODBC). Also
> TDBImage is no good if you want to use jpg files. I found an alternative
> - EDBImage.
>
> Hope that helps. Good luck.
>
> Julius Tuskenis
>
>

pgsql-general by date:

Previous
From: "Teemu Juntunen"
Date:
Subject: Re: Bind message has 6 results formats but query has 5 columns
Next
From: "dbalinglung"
Date:
Subject: Re: Load Image File From PostgreSQL DB