Re: Saving a jpg into Postgresql table - Mailing list pgsql-general

From Kaloyan Iliev
Subject Re: Saving a jpg into Postgresql table
Date
Msg-id 44EEA264.2010009@faith.digsys.bg
Whole thread Raw
In response to Saving a jpg into Postgresql table  (Gibson <gibson@nexgenstudio.com>)
Responses Re: Saving a jpg into Postgresql table
List pgsql-general
Gibson wrote:

> Hi guys,
>
> I have a projects using ASP.NET (VB.net) where i upload a jpeg file
> using a web form and then save the jpeg file into a table. I've
> decided to use "Oid" instead of "Bytea" as i heard that "Oid" is more
> memory efficient. So can anyone point me to a website or link where i
> can see the VB.net or C# code that does the SQL insert of the jpeg
> file into the "Oid" data type column and also how to do a SQL select
> to retrieve and display the image on a web form? Thanks

Hi,
I have problem like yours and I solve it like that:
I transform the jpeg to Base64 text and then store it into normal text
field.
It takes aproximately 25-30% more disk space but is much easier for me
to operate with it.
When I read the object from the database I decode it and I have the file
in the original format.


Regards,

  Kaloyan Iliev

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Inserting Data
Next
From: Rafal Pietrak
Date:
Subject: Re: multimpe records output from a 'no-table' source