Date: Thu, 4 Mar 2004 09:54:21 +0200 (EET)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Joe Conway <mail@joeconway.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Encoding bytea
In-Reply-To: <40466342.1000608@joeconway.com>
Message-ID: <Pine.LNX.4.44.0403040953340.2444-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

O kyrios Joe Conway egrapse stis Mar 3, 2004 :

> Achilleus Mantzios wrote:
> 
> > is there a way to encode a bytea in such a way that the resulting
> > text stream be readily available (\\ escaped for unprintable chars) for 
> > usage in an insert statement?
> > 
> > None of base64,hex,escape options in encode() seem to produce
> > anything close.
> > 
> > This is meant to be used with generating insert statements in xml files
> > for remote processing.
> 
> Is this what you need?

Yes thanx. ( i always forget about the casting function trick)

> 
> create table t(f bytea);
> insert into b values ('a\\003\\000\\001b');
> 
> create or replace function bytea2text(bytea) returns text as '
> begin
>   return $1;
> end;
> ' language plpgsql;
> 
> regression=# select 'insert into t values(' || 
> quote_literal(bytea2text(f)) || ');' from t;
>                    ?column?
> --------------------------------------------
>   insert into t values('a\\003\\000\\001b');
> (1 row)
> 
> regression=# insert into t values('a\\003\\000\\001b');
> INSERT 292656 1
> 
> HTH,
> 
> Joe
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

-- 
-Achilleus