1 PgSanity checks the syntax of PostgreSQL SQL files.
3 It does this by leveraging the ecpg command which is traditionally
4 used for preparing C files with embedded SQL for compilation.
5 However, as part of that preparation, ecpg checks the embedded SQL
6 statements for syntax errors using the exact same parser that is in
9 So the approach that PgSanity takes is to take a file that has a list
10 of bare SQL in it, make that file look like a C file with embedded
11 SQL, run it through ecpg and let ecpg report on the syntax errors of
14 WWW: https://github.com/markdrago/pgsanity