Reading bytes as a string from Db

Question

I have one table that has 2 fields one(container_id) for numeric type and another for byte type(coDearntainer_objects) . I would like to read the byte field(container_objects) as a string for corresponding (container_id) field.

How could I do this? I am using Postgresql Db Table Structure:

CREATE TABLE container
(
  ct_id numeric,
  container_object bytea
)

Answer 1

Take a look at encode() to transform a bytea to a string.