I have a view I created that is pulling its data from tables in a postgreSQL. One of the fields has the output type of "BLOB" and in the field...instead of the values, "[BINARY DATA]" is shown. When I would come across this issue in the past in greenplum i would type in the follow syntax: pg_catalog.encode(pg_catalog.decode(encode(FIELD NAME, 'escape'), 'hex'), 'escape') .
Using this syntax would update the BLOB field to show me the actual text in the field. Can you please advise how I can update the output of my BLOB fields to actually show the text in the field instead of "[BINARY DATA]"