One of the new features in PostgreSQL 9.3 is CREATE SCHEMA IF NOT EXISTS someschema;
. We were so excited about this new feature that we started using it in the tiger geocoder loader routine. For some reason we thought it was available since 9.1 which gained CREATE TABLE IF NOT EXISTS sometable;
which we noted in Sweat the small stuff, it really matters