pgAdmin III: How to view a blob?

postgresql pgadmin
Haroldo_OK picture Haroldo_OK · Feb 14, 2013 · Viewed 26.1k times · Source

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?

Answer

Stupidfrog picture Stupidfrog · May 25, 2015 
SELECT encode(blobdata::bytea, 'escape') FROM table as o where o.blobdata != ''

where

  1. blobdata is the bytea column (blob)
  2. "table" is the table that contains the column blobdata

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later I opened the UI and create the server …

Read More
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove table. Ok, now I …

Read More