How to View PDF stored in PostgreSQL BYTEA field

Some time you need view pdf stored in PostgreSQL bytea field, how to do it?

I suggest you try PGLobEditor, you can download it form here: http://www.withdata.com/down/PGLobEditor.exe .

Run PGLobEditor, execute query, and click the “BLOB” grid that contains PDF data.

then you’ll see the PDF content.