pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)
>





view thread (4+ messages)  latest in thread

Message-ID: <3BE120D1.3060406@www.aldratech.com>
Permalink:  ../3BE120D1.3060406@www.aldratech.com/
Also on:    postgresql.org/message-id/3BE120D1.3060406@www.aldratech.com

 · 

reply

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