From: beyaNet Consultancy <beyanet@ntlworld.com>
To: pgsql-sql@postgresql.org
Subject: Read bytea column from table and convert into base64.....
Date: Fri, 5 Mar 2004 23:59:50 +0000
Message-ID: <30AF055A-6F01-11D8-B866-0003938366A4@ntlworld.com> (raw)
Hi,
I have a bytea column which I want to convert into base64. At the
moment I am reading the bytea colum into my java app as a byte[]. I am
then calling another static method to convert the byte[] into base64. I
want postgreSQl to handle the conversion so my app can read in the
base64 string.
So for example:
select (base64)byteaColumn from tableName where artistID = x
many thanks in advance
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: beyanet@ntlworld.com
Subject: Re: Read bytea column from table and convert into base64.....
In-Reply-To: <30AF055A-6F01-11D8-B866-0003938366A4@ntlworld.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