PostgreSQL SQL Syntax Support¶

This page documents the SQL syntax support for PostgreSQL in the General SQL Parser.

Coverage Report¶

For detailed coverage statistics and test results, visit our comprehensive coverage report:

The coverage report includes: - Parsing success rates for various SQL constructs - Detailed test results with source documentation - Interactive interface to explore supported syntax - Real-world SQL examples from PostgreSQL documentation

Key Features Supported¶

Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
PostgreSQL-specific data types (JSON, JSONB, Arrays, etc.)
Advanced window functions and CTEs
Stored procedures and functions (PL/pgSQL)
Full-text search capabilities
Partitioning and inheritance features