SPI and bytea columns

From: "Wolfgang Reichart" <wolfgang_reichart(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SPI and bytea columns
Date: 2004-05-10 11:17:57
Message-ID: BAY7-F57DQWifVG6wVE0000ef17@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hello!
i want to insert jpeg pictures into a bytea field and i implemented a
SPI extension. this function reads the jpeg-file from the filesystem,
converts it into a octal-coded string to pass the sql-parser, and then
exec's the insert statement. this is rather slow, and i'd like to insert
using lower level postgres functions that handle binary data without base64-
or escaped en-/decoding.

did anyone something like this in the past?

thanks,
(reply to) wolfgang_reichart(at)hotmail(dot)com

_________________________________________________________________
Schaffen Sie das Platzproblem in Ihrem E-Mail-Konto für immer aus der Welt!
http://join.msn.com/?pgmarket=de-at&DI=43&XAPID=1817

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-05-10 11:46:32 Re: CLUSTER locking
Previous Message Christopher Kings-Lynne 2004-05-10 08:01:52 CLUSTER locking