To add a new SQL test - add sql script to run to zenith_regress/sql/testname.sql - add expected output to zenith_regress/expected/testname.out - add testname to parallel_schedule That's it. For more complex tests see PostgreSQL regression tests. These works basically the same.