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

> On 7 Mar 2024, at 4:56 PM, Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
>
> Hello
>
> I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors.

https://scratch.mit.edu/ would be more suitable, maybe ?

>
> Python IMHO is too advanced, too rich, weird indentation rules, no simple for loop etc.
>
> C, ok, punishing little kids with segmentation faults, calling by value VS by reference and 3ple pointers is pure sadism.
>
> So this brings me to memory good old PASCAL from the time I was junior, circa 1986. PL/SQL resembles PASCAL heavily. Everything seems well defined, strong typing, simplicity, I think it has everything a programming language should have in order to be taught as an introductory language. But it lacks IO and file handling.
>
> So, I ask, have there been any efforts to bring PL/PGSQL to the terminal?

Imho the best you can do is bash + psql + pl/pgsql , via heredocs .
pql <<EOF
<pgsql code.
EOF
It does require lot’s of care with variables though https://www.depesz.com/2023/05/28/variables-in-psql-how-to-use-them/

But one can get fairly creative.

>
> Thanks!
>
>
>