OT: How to read PgSQL quarantined data

Christian Roessner c+amavis at roessner-network-solutions.com
Fri Jul 29 13:33:26 CEST 2011


Hi,

I use Postgres as SQL server for quarantined messages in amavis 2.7.0. I
have round abozt 3.600 mails now inside the quarantine and I wanted to
view some of them.

If using pgsql and do a simple

SELECT * FROM public.quarantine

, all content is displayed in binarya (Hex?) format.

PgAdmin III also does not "convert" data.

So can somebody help me with pgsql and tell me, if I can make the data
visible?

Thanks in advance
Christian
-- 
Roessner-Network-Solutions
Bachelor of Science Informatik
50°34.725'N, 08°40.904'O, Nahrungsberg 81, 35390 Giessen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com


More information about the amavis-users mailing list