For #sqlserver I use #tsqlt for unit testing. What would be a good #postgresql equivalent?

One of the things I like most about tsqlt is that I can use my existing skill set to develop tests instead of learning a completely different language.

#sqlfamily What's your methodology when it comes to mocking up data for #tSQLt?

Say you have a user management system. Do you create a standard set of user data that you then call from all tests setup procedure? Or to you tailor the dataset to the specific test? I like the idea of reusing datasets but worry about the overhead. But then again I also worry about not catching all possible error modes because we didn't account for this new type of user in every test.

#sqlserver #tsql