• 

  okbob/plpgsql_check

  

  github.com

  plpgsql_check: A PL/pgSQL Code Checker — This is quite specialized but if you’re looking to find any errors lurking in your PL/pgSQL functions, it could be a lifesaver. The project is quite old but has been kept up to date and runs on modern Postgres versions.

  extension function-plpgsql plpgsql postgresql postgresql-extension repository

  • Add  

  3

Appears in lists (2)

• Issue 302 - Creating fractals with SQL and Postgres
• Issue 363 - Amazon RDS now lets you take Postgres from outhouse to inhouse

More like this (3)

• 

  Abusing PostgreSQL as an SQL beautifier - Cybertec

  

  cybertec-postgresql.com

  Playing with Postgres's 'SQL Beautification' Skills — It’s common to use a ‘SQL beautifier’ to turn...

  Playing with Postgres's 'SQL Beautification' Skills — It’s common to use a ‘SQL beautifier’ to turn otherwise ugly queries into more attractively formatted strings.. but did you know Postgres has some built-in functionality you can misuse to similar ends? I’m not sure how useful this is but it’s an interesting corner of Postgres to be aware of.

  • Read
  • Add  

  
• Planet PostgreSQL

  

  postgresql.org

  • Read
  • Add  

  
• Pavel Stehule's blog: Why you need plpgsql_check (if you write procedures in PLpgSQL)

  

  okbob.blogspot.com

  Why You Need plpgsql_check if You Write Procedures in PL/pgSQL — PL/pgSQL lets you write and...

  Why You Need plpgsql_check if You Write Procedures in PL/pgSQL — PL/pgSQL lets you write and execute some pretty advanced logic directly within Postgres and SQL queries and plpgsql_check can help you with performance and SQL injection problems.

  • Read
  • Add  

  1