$ sudo -u postgres psql < schema_dump.sql 
You are now connected to database "postgres".
SET
SET
SET
ERROR:  role "apache" cannot be dropped because some objects depend on it
DETAIL:  29 objects in database apache
ERROR:  role "apache" already exists
ALTER ROLE
ERROR:  current user cannot be dropped
ERROR:  role "postgres" already exists
ALTER ROLE
DROP ROLE
CREATE ROLE
ALTER ROLE
DROP DATABASE
CREATE DATABASE
DROP DATABASE
CREATE DATABASE
REVOKE
GRANT
REVOKE
GRANT
You are now connected to database "apache".
SET
SET
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_test" does not exist
ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...name AS state, icc_states.abbrev AS state_abbrev, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_with_admin" does not exist
ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_with_country" does not exist
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
REVOKE
REVOKE
GRANT
You are now connected to database "postgres".
SET
SET
SET
SET
SET
REVOKE
GRANT
You are now connected to database "shaun".
SET
SET
SET
SET
SET
REVOKE
GRANT
You are now connected to database "template1".
SET
SET
SET
SET
SET
COMMENT
REVOKE
GRANT