How to use BYTEA type? - Mailing list pgsql-sql

From Christopher Sawtell
Subject How to use BYTEA type?
Date
Msg-id 20011101084028.47F4CD21EF@deborah.paradise.net.nz
Whole thread Raw
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: "Aasmund Midttun Godal"
Date:
Subject: Re: transposing data for a view
Next
From: Radu-Adrian Popescu
Date:
Subject: Re: How to use BYTEA type?