Re: How to use BYTEA type?

On Thu, 1 Nov 2001, Radu-Adrian Popescu wrote:

> Doing
>
> template1=> SELECT proname from pg_proc ;
>         proname
> ------------------------
>  boolin
>  boolout
>  byteain
>  byteaout
>
> you can see there is a byteaout function also. However, these are
> undocumented in the interactive docs, which is a shame indeed. I only
> learned of byteain/out after reading your email.
>
> If some of the postgresql guys could point the location of the
> documentation of undocumented functions  :-)  that'd be great.

AFAIK, the in and out functions are *not* meant to be called by
users.  They're used by the system and I think they technically
take pointer values.  To use bytea correctly, I believe you are
supposed to do some escaping and place the value into the
insert statement.

insert into table values ('\011\005\\000afkajdd\011');
(note the double backslash on the null byte).  And you should
get the value back from a straight select on the column I believe.