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)
>