Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

> On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud <a.mantzios@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,
andcreate 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
differentand much more complex problem.  PL/pgSQL uses the PostgreSQL query execution machinery to run pretty much
anythingthat is not a control structure, and the language is very focused on interacting with the database.  I doubt it
wouldbe worth anyone's time to try to build some kind of minimal framework that implements the SPI to allow PL/pgSQL to
operatewithout PostgreSQL.