Tools and tips for develpment in PL/pgSQL language
From PostgreSQL wiki
- Ora2pg - conversion from Oracle to Postgres (conversion from PL/SQL to PL/pgSQL is included)
- plpgsql_check - multi-purpose tool for PL/pgSQL developers based on static analyse of source code - check validity of SQL identifiers, detect SQL injection and some performance problems. This tool use PL/pgSQL debug API, and can be used for code profiling, tracing. It can display dependency list and two code coverage metrics.
- plProfiler - profiler for PL/pgSQL with nice html reports (with flame graphs)
- pldbgapi - this extension allows to use remotely PL/pgSQL debug API. It is necessary for using PLpgSQL interactive debugger from PgAdmin.