pgsql: add tests with alert metadata, adjust pcap_cnt - v2

[jufajardini]

Check for transaction metadata in PGSQL alerts. Add engine-analysis tests for the used rules, as well, to better describe them and compare with expected behavior.

Related to Task #7000

https://github.com/OISF/suricata-verify/pull/1990 without force-pushes

Suricata PR

https://github.com/OISF/suricata/pull/11547

Ticket

If your pull request is related to a Suricata ticket, please provide the full URL to the ticket here so this pull request can monitor changes to the ticket status:

Redmine ticket: https://redmine.openinfosecfoundation.org/issues/7113 https://redmine.openinfosecfoundation.org/issues/7000