Using PostgreSQL 8.4, how to convert bytea to text value in postgres?
For followers, since this seems to be the canonical question for &quot;converting bytea to text&quot; (i.e. so you can actually see it in pgAdmin etc.) . Here's how to just get it viewable (assuming your_column_name is
type bytea)
select encode(table.your_column_name, 'escape') as your_alias_name from table_name