How to get all problems history from PostgreSQL

[bujaa]

I want to retrive all the problems that ever happened in zabbix.
I can access problems history using GUI up to 3 months past but I need to get them directly from Postgres.
I managed to find public_problems table which conatins all the information i need but there is one issue - there are no data older than 48 hours.
Do somone know where all problems are stored? If i can access them from GUI they must be somewhere in database.
I noticed that there is another table called public_events and all events including problems are stored there. Problem is this data are not usefull at all bicous they lack information (columns) stored in public_problems.
Is there any antoher table where zabbix store problems after deleting theme from public_problems table?
If someone have access to zabbix postgres documentation it would be greate of help. I search all of the internet and unfortunetly didn't find anything usefull.

[vladimir_lv]

Hi!
The table events consists of the events generated in Zabbix:
Use the query:

select * from events where (object = 0 or object=6);

0 - Trigger
6 - Service