From: Radu-Adrian Popescu <radu.popescu@www.aldratech.com>
To: csawtell@paradise.net.nz
Cc: pgsql-sql@postgresql.org
Subject: Re: How to use BYTEA type?
Date: Thu, 01 Nov 2001 12:15:45 +0200
Message-ID: <3BE120D1.3060406@www.aldratech.com> (raw)
References: <20011101084028.47F4CD21EF@deborah.paradise.net.nz>
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.
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)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: radu.popescu@www.aldratech.com, csawtell@paradise.net.nz
Subject: Re: How to use BYTEA type?
In-Reply-To: <3BE120D1.3060406@www.aldratech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox