setup_dbase.sql

/* create some database and administrator account, for example. */
create user dummy_admin;
alter user dummy_admin with password 'dummy_pass';
create database "dummy_dbase" owner dummy_admin;
\c "dummy_dbase"
create extension if not exists postgis;
create extension if not exists fuzzystrmatch;
create extension if not exists postgis_tiger_geocoder;
create extension if not exists postgis_topology;
\c postgres