Formal Syntax of PL/pgSQL

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: mohamedhussein10445(at)gmail(dot)com
Subject: Formal Syntax of PL/pgSQL
Date: 2024-12-05 14:33:16
Message-ID: 173340919600.2556776.5021231474261341976@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/index.html
Description:

I am currently working on a project that involves analyzing and building AST
(Abstract Syntax Tree) interfaces for PL/pgSQL in TypeScript. My goal is to
model the entire syntax of PL/pgSQL comprehensively, covering all its
constructs exactly as they are understood syntactically by PostgreSQL when
processing functions or procedures.

While exploring the official documentation, I noticed that commands like
CREATE TABLE or SELECT are documented with clear and formalized syntax
structures, which are incredibly helpful for developers needing to parse or
programmatically interact with these commands. However, for PL/pgSQL, I
couldn't find a similar consolidated syntax reference. For instance, while
the documentation explains the supported declarations, control structures,
and statements, it lacks a unified formal syntax block that encapsulates the
entire language as PostgreSQL interprets it.

Would it be possible to provide such a formal syntax reference for PL/pgSQL,
or point me toward an existing resource that captures this? Having access to
a detailed and comprehensive syntax description would be immensely helpful
for projects requiring precise parsing and manipulation of PL/pgSQL code.

Thank you for your time and for the incredible work you do on PostgreSQL.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2024-12-05 16:44:34 Re: Formal Syntax of PL/pgSQL
Previous Message Greg Sabino Mullane 2024-12-04 15:56:49 Re: Does NOTIFY leak information?