diff options
Diffstat (limited to 'system/pgsanity/README')
| -rw-r--r-- | system/pgsanity/README | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/system/pgsanity/README b/system/pgsanity/README new file mode 100644 index 0000000000..1e83b1a933 --- /dev/null +++ b/system/pgsanity/README @@ -0,0 +1,10 @@ +PgSanity checks the syntax of PostgreSQL SQL files. + +It does this by leveraging the ecpg command which is traditionally used +for preparing C files with embedded SQL for compilation. However, as +part of that preparation, ecpg checks the embedded SQL statements for +syntax errors using the exact same parser that is in PostgreSQL. + +So the approach that PgSanity takes is to take a file that has a list of +bare SQL in it, make that file look like a C file with embedded SQL, run +it through ecpg and let ecpg report on the syntax errors of the SQL. |