The state of the art of this has advanced significantly with the advent of "extension" support, as seen in CREATE EXTENSION in 9.1+: http://www.postgresql.or

The state of the art of this has advanced significantly with the advent of "extension" support, as seen in CREATE EXTENSION in 9.1+: http://www.postgresql.org/docs/9.1/static/sql-createextension.html The new way is much better than the old way.