If you've run Rails tests or specs against a PostgreSQL database, you're probably used to seeing an endless stream of messages march down the screen: NOTICE: CREATE TABLE will create implicit sequence "authorizations_id_seq" for serial column "authorizations.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "authorizations_pkey" for table "authorizations" NOTICE: CREATE TABLE will create implicit sequence "catalog_organizations_id_seq" for serial column "catalog_organizations.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "catalog_organizations_pkey" for table "catalog_organizations" NOTICE: CREATE TABLE will create implicit sequence "catalog_products_id_seq" for serial column "catalog_products.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "catalog_products_pkey" for table "catalog_products" Turns out that you don't have to accept all that chatter. To turn it off, just put this in your .bash_profile or other startup file: 

export PGOPTIONS='-c client_min_messages=WARNING'
Voila, all notices will be suppressed and hidden.