I have found it to be very flaky. I also found some issues in defining functions. The functions don't work well with semi colon as a separator so I used GO as a separator to work.
Since then I have switched to DB fiddled and it's working well for me. It supports more variants of pgsql also.