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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
