From: | Christophe Pettus <xof(at)thebuild(dot)com> |
---|---|
To: | Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |
Date: | 2024-03-07 15:57:57 |
Message-ID: | 405C1494-7432-442B-AB28-EE04D38E989B@thebuild.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-03-07 16:16:19 | Re: v11.5- v15.3 upgrade (linux) |
Previous Message | Ron Johnson | 2024-03-07 15:56:55 | Re: v11.5- v15.3 upgrade (linux) |