psql -U postgres -c "create database workshop;" psql -U postgres -d workshop -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql psql -U postgres -d workshop -f /usr/share/postgresql/9.1/contrib/postgis-2.0/spatial_ref_sys.sql