EDB Postgres Advanced Server SQL Parser for Java

EDB Postgres Advanced Server SQL that GSP parses

CREATE OR REPLACE PACKAGE emp_pkg IS
  PROCEDURE hire_emp(p_name VARCHAR2);
  FUNCTION get_salary(p_id NUMBER) RETURN NUMBER;
END emp_pkg;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvedb);
parser.sqltext = sql; // the EDB Postgres Advanced Server SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Java edition only. The .NET library has no EDB Postgres Advanced Server grammar, so this dialect cannot be parsed from C# or VB.NET. See the .NET SQL Parser SDK for the dialects it does cover.

What GSP handles in EDB Postgres Advanced Server

• CREATE OR REPLACE PACKAGE specifications and package bodies
• %TYPE and %ROWTYPE anchored declarations
• Explicit cursors with OPEN / FETCH / %FOUND / %NOTFOUND / %ROWCOUNT
• VARRAY, TABLE OF, and record collection types
• Compound and INSTEAD OF DML triggers
• EXCEPTION handlers with PRAGMA EXCEPTION_INIT
• PostgreSQL core DDL and DML, including JSON types, in the same grammar
• Procedural SQL: EDB Postgres Advanced Server SPL — packages, procedures, functions, triggers, anonymous DECLARE/BEGIN blocks, cursors, exception handlers, and FORALL / BULK COLLECT bulk operations

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for EDB Postgres Advanced Server.

Recent EDB Postgres Advanced Server parser updates

• 2026-03-22 [EDB] Comprehensive EDB Postgres SPL support (triggers, types, collections, cursors, exceptions, loops, bulk operations)

Full history in the release notes.