Established coding standards for pl/pgsql code
- by jb01
I need to standardize coding practises for project that compromises, among others has pl/pgsql database, that has some amount of nontrivial code.
I look for:
Code formatting guidelines, especially inside procedures.
Guidelines on what constructs are consigered unsafe (if any)
Naming coventions.
Code documentation conventions (if this is pracicised)
Any hints to documets that define good practises in pl/pgsql code? If not i'm looking for
hints to practices that you consider good.
There is related question regarding TSQL: Can anyone recommend coding standards for TSQL?, which is relevant to psql as well, but I need more information on stored procedures.
Other related questions:
http://stackoverflow.com/questions/1070275/what-indenting-style-do-you-use-in-sql-server-stored-procedures