pgTAP
(http://pgtap.org) usage example.
$ vagrant up
$ cd ansible
$ cp ansible.cfg.dist ansible.cfg
$ ansible-galaxy install -r requirements.yml
$ ansible-playbook -i inventory/vagrant playbook.yml
$ vagrant ssh
$ sudo -i -u pgtap
$ cd /vagrant/
$ pg_prove -v t/*.sql