Processed Message 1

...

Processed Message 558

All Done!

Теперь можно провести анализ содержимого IMAP-каталога:

# psql -U dbmail dbmail

dbmail=# select user_idnr, userid from dbmail_users;

 user_idnr |             userid             

-----------+--------------------------------

         1 | __@!internal_delivery_user!@__

         2 | anyone

         3 | test

(записей: 3)

dbmail=# select mailbox_idnr, owner_idnr, name from dbmail_mailboxes where owner_idnr = 3;

 mailbox_idnr | owner_idnr |        name       

--------------+------------+--------------------

            1 |          3 | INBOX

            3 |          3 | Trash

            4 |          3 | INBOX/DBMail-Users

(записей: 3)

dbmail=# select mailheader(messageblk, 'User-Agent'), count(*)

dbmail=# from dbmail_messages inner join dbmail_messageblks