Re: How to use BYTEA type?

Doing

template1=> SELECT proname from pg_proc ;       proname        
------------------------boolinbooloutbyteainbyteaout

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.


Radu-Adrian Popescu
DBA/programmer at www.aldratech.com


Christopher Sawtell wrote:

>Greetings folks,
>
>  Please could a kind soul tell be how to extract data from a BYTEA type of  
>field into a file, or better still tell me where I can find some doco?
>
>This is the table:-
>
>create table fax_info ( id serial, comment text, image bytea) ;
>
>This appears to work ( no erorr messages ):-
>
>chris=# insert into fax_info ( comment, image ) values
>( 'Faking it with a computer', byteain ('picture.pgm.gz'));
>INSERT 18772 1
>
>Is this correct?
>
>Now, how do I get my picture out again?
>
>TNX 10^6
>
>Sincerely etc.
>
>Christopher Sawtell.
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>