system/pgsanity: Added (SQL syntax checker for PostgreSQL).

Signed-off-by: Willy Sudiarto Raharjo <willysr@slackbuilds.org>

1 files changed, 10 insertions, 0 deletions

diff --git a/system/pgsanity/README b/system/pgsanity/README
new file mode 100644
index 0000000000000..1e83b1a9332e6
--- /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.