[SQL] How to use BYTEA type?

[Christopher Sawtell]

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 [EMAIL PROTECTED])