Re: Load Image File From PostgreSQL DB

From: "dbalinglung" <alamsurya(at)centrin(dot)net(dot)id>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Load Image File From PostgreSQL DB
Date: 2008-12-30 10:28:39
Message-ID: 047129C969DB45718F9BFFEDFF1D9E45@alam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)tuskenis(at)gmail(dot)com>
>Cc: <pgsql-general(at)postgresql(dot)org>
>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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dbalinglung 2008-12-30 11:18:55 Re: Load Image File From PostgreSQL DB
Previous Message Reg Me Please 2008-12-30 09:02:04 Re: [PGSQL 8.3.5] Use of a partial indexes