From da8accbc1b557f31c0c7141897a6da324eb89b9e Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Audrius=20Ka=C5=BEukauskas?= Date: Mon, 26 May 2014 09:16:12 +0700 Subject: system/pgsanity: Added (SQL syntax checker for PostgreSQL). Signed-off-by: Willy Sudiarto Raharjo --- system/pgsanity/README | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 system/pgsanity/README (limited to 'system/pgsanity/README') diff --git a/system/pgsanity/README b/system/pgsanity/README new file mode 100644 index 000000000000..1e83b1a9332e --- /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. -- cgit v1.2.3