Tools and tips for develpment in PL/pgSQL language

From PostgreSQL wiki
Jump to: navigation, search
  • 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.