What is the standard de facto unit test framework for Postgres?
pgTAP

pgTAP is the only I know that is ever even talked about. 


  pgTAP is a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions.



github
web
pgxn