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