| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
| Cc: | Dennis Gearon <gearond(at)fireserve(dot)net>, pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: bytea |
| Date: | 2004-05-11 18:07:46 |
| Message-ID: | 20040511180746.GA4486@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, May 11, 2004 at 09:30:15AM -0700, Jonathan Bartlett wrote:
> > Also, if I wanted to put a *.pdf file in a bytea column, what functions
> > do I use to escape any characters in it?
>
> What programming language are you using?
Apparently if you are using C and libpq, you can use the version 3
protocol functions to send binary data without having to escape it. I
haven't done it though so I may be wrong, but if I'm right please
somebody tell me because I usually recommend this :-)
Also if it works it would be useful to update the Perl/PHP/etc
interfaces to use it.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sudor es la mejor cura para un pensamiento enfermo" (Bardia)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zuhans@iname.com | 2004-05-11 18:09:46 | security question |
| Previous Message | Carl E. McMillin | 2004-05-11 18:03:28 | Re: Cancel query based on a timeout |