Look into PL/pgSQL [1]. PostgreSQL also offers a few other languages such as Python and Perl [2]. Please note that the individual extensions have to be installe

Look into PL/pgSQL [1]. PostgreSQL also offers a few other languages such as Python and Perl [2]. Please note that the individual extensions have to be installed. [1]: https://www.postgresql.org/docs/current/static/plpgsql.html https://www.postgresql.org/docs/current/static/plpgsql.html [2]: https://www.postgresql.org/docs/current/static/server-programming.html https://www.postgresql.org/docs/current/static/server-progra...