pgAdmin III: How to view a blob?
I understand that PostgreSQL writes BLOB content to a separate table, but is there any way to view the blob contents in an easy and convenient way from inside pgAdmin?
Solution 1:
SELECT encode(blobdata::bytea, 'escape') FROM table as o where o.blobdata != ''
where
- blobdata is the bytea column (blob)
- "table" is the table that contains the column blobdata