Re: bytea - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: bytea
Date
Msg-id 20040511180746.GA4486@dcc.uchile.cl
Whole thread Raw
In response to Re: bytea  (Jonathan Bartlett <johnnyb@eskimo.com>)
List 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)

pgsql-general by date:

Previous
From: "Carl E. McMillin"
Date:
Subject: Re: Cancel query based on a timeout
Next
From: "zuhans@iname.com"
Date:
Subject: security question