Postgresql - how to convert bytea to text or string in Java

Question

I have a column that is bytea in postgres, and I can use a statement like this to get this kind of output:

select encode(mycolumn,'escape') from personTable;

and get:

254\355\000?sr\000?java.util.HashMap??\332\301\303?`\321?\000?F\000
loadFactorI\000 thresholdxp?@\000\000\000\000\000?w?\000\000\000?\000\000\000?t\000?      
userIdt\000
USER2200000x

How would I see this in plain text? It is indeed storing a java.util.HashMap-

luksmir · Accepted Answer · 2013-07-04 07:20:57Z

5

This is really a Java issue rather than a PostgreSQL issue. personTable.mycolumn is holding a byte-string that was created using the Java Serialization API, and to retrieve the original object that the byte-string represents, you need to use that same API. (See "Discover the secrets of the Java Serialization API" for sample code.)

edited Jul 4, 2013 at 7:20

luksmir

3,1545 gold badges25 silver badges38 bronze badges

answered Mar 17, 2012 at 14:10

ruakh

185k29 gold badges292 silver badges324 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

chrismarx Over a year ago

ok, yup this makes sense, the application is saving serialized objects, i just didn't realize there wasnt a way to see the plain text in postgres. thanks!

Amit Over a year ago

How you solved the problem ? I also want to convert a bytea of postgres to Java String. please see my question here dba.stackexchange.com/questions/53309/…

Collectives™ on Stack Overflow

Postgresql - how to convert bytea to text or string in Java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related