Re: Read bytea column from table and convert into base64.....

O kyrios beyaNet Consultancy egrapse stis Mar 5, 2004 :

> 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

You can use encode function as :

select encode(byteaColumn,'base64') from tableName where artistID = x

>
> many thanks in advance
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
-Achilleus