[postgres] Rewrite tests for new test interface

This fixes the tests for #9 to conform to the new test interface introduced in #12.