Saving a jpg into Postgresql table

From: Gibson <gibson(at)nexgenstudio(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Saving a jpg into Postgresql table
Date: 2006-08-24 10:25:28
Message-ID: 44ED7E98.6090600@nexgenstudio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
--

Cheers
Gibson Tang
Game Programmer
179, River Valley Building #04-09
Singapore 179033
Nexgen Studio <www.nexgenstudio.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-08-24 11:17:45 Re: XPath and XML support
Previous Message Martijn van Oosterhout 2006-08-24 09:57:15 Re: invalid byte sequence ?