pg_parse 0.12.0

PostgreSQL parser that uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

const char* tests[] = {
  "",
  "",
  "SELECT 1",
  "loc=0,len=8",
  "SELECT 1; SELECT 2",
  "loc=0,len=8;loc=9,len=9",
  "SELECT 1; SELECT 2; SELECT 3",
  "loc=0,len=8;loc=9,len=9;loc=19,len=9",
  "SELECT /* comment with ; */ 1; SELECT 2",
  "loc=0,len=29;loc=30,len=9",
  "SELECT --othercomment with ;\n 1; SELECT 2",
  "loc=0,len=31;loc=32,len=9",
  "CREATE RULE x AS ON SELECT TO tbl DO (SELECT 1; SELECT 2)",
  "loc=0,len=57",
  "SELECT 1;\n;\n-- comment\nSELECT 2;\n;",
  "loc=0,len=8;loc=11,len=20"
};

size_t testsLength = __LINE__ - 4;