Michael Holzman <michaelholzman@gmail.com> writes:
> What are the ways of development and debugging of pl/SQL code in PG? Any
> suggestions/hints will be very appreciated.
The standard low-tech way is to sprinkle RAISE NOTICE (or maybe RAISE LOG)
actions throughout your function. The only real alternative I know about
is EDB's pl/debugger, which I think used to be available standalone but
these days it seems like they only provide it with the pgAdmin GUI.
https://www.pgadmin.org
regards, tom lane