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

From Julius Tuskenis
Subject Re: Load Image File From PostgreSQL DB
Date
Msg-id 4959D1DF.6070007@gmail.com
Whole thread Raw
In response to Load Image File From PostgreSQL DB  ("dbalinglung" <alamsurya@centrin.net.id>)
List pgsql-general
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



dbalinglung rašė:
> Dear Expert,
>
>
> I'm sorry for my newbie question, I have a dificulty to load image
> file from field OID type on PostgreSQL with Borland Delphi 7.
>
> I would like to showing image file with TDBImage component to Delphi
> Form, but the image file can't display, any sugestion for me about how
> can i do to show the image file with Borland Delphi 7 and PostgreSQL
> 8.2.x. The image file saving on PostgreSQL 8.2.X table with OID Field
> Type.
>
>
> Many thanks and Regards,
>
>
> *Alam Surya*
>

pgsql-general by date:

Previous
From: "dbalinglung"
Date:
Subject: Load Image File From PostgreSQL DB
Next
From: Christian Schröder
Date:
Subject: Re: Query planner and foreign key constraints