X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1322CD1D14B for ; Fri, 5 Mar 2004 23:59:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14685-03 for ; Fri, 5 Mar 2004 19:59:53 -0400 (AST) Received: from mta05-svc.ntlworld.com (mta05-svc.ntlworld.com [62.253.162.45]) by svr1.postgresql.org (Postfix) with ESMTP id 4565BD1D108 for ; Fri, 5 Mar 2004 19:59:49 -0400 (AST) Received: from [81.98.165.129] by mta05-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040305235859.BYAB27661.mta05-svc.ntlworld.com@[81.98.165.129]> for ; Fri, 5 Mar 2004 23:58:59 +0000 Mime-Version: 1.0 (Apple Message framework v612) Content-Transfer-Encoding: 7bit Message-Id: <30AF055A-6F01-11D8-B866-0003938366A4@ntlworld.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-sql@postgresql.org From: beyaNet Consultancy Subject: Read bytea column from table and convert into base64..... Date: Fri, 5 Mar 2004 23:59:50 +0000 X-Mailer: Apple Mail (2.612) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/47 X-Sequence-Number: 17146 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