> On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud
> <a.mantz...@cloud.gatewaynet.com> wrote:
> So, I ask, have there been any efforts to bring PL/PGSQL to the terminal?
Strictly speaking, of course, you can use PL/pgSQL from the terminal already:
just use psql, connect to the database, and create and run functions and
procedures as much as you like.
If the question is, "Have there been any efforts to implement a PL/pgSQL
interpreter without PostgreSQL?", that's a different and much more complex
problem. PL/pgSQL uses the PostgreSQL query execution machinery to run pretty
much anything that is not a control structure, and the language is very focused
on interacting with the database. I doubt it would be worth anyone's time to
try to build some kind of minimal framework that implements the SPI to allow
PL/pgSQL to operate without PostgreSQL.