[ADMIN] Postgresql scheme standards tool

[Robert Matthew Cook]

Is anyone aware of tools which can be used to enforce or test schema
standards on PostgreSQL 9.0? Examples being something like: 1)
Fail/rollback DDL attempting to create a table in the public schema 2)
Create a scheduled process which raises alerts for columns of datatype XML

Thanks, Robert