| 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: | Whole Thread | Raw Message | 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
| 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 |