SPI and bytea columns - Mailing list pgsql-hackers

From Wolfgang Reichart
Subject SPI and bytea columns
Date
Msg-id BAY7-F57DQWifVG6wVE0000ef17@hotmail.com
Whole thread Raw
Responses Re: SPI and bytea columns  (Mike Mascari <mascarm@mascari.com>)
List 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@hotmail.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



pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Advice regarding configuration parameters
Next
From: Bricklen
Date:
Subject: Re: Adding MERGE to the TODO list (resend with subject)