- Database setup
CREATE DATABASE <databasename>;
GRANT ALL PRIVILEGES ON DATABASE <databasename> TO <postgresuser>;
\c <databasename>
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO <postgresuser>;- Run schema against database
psql -U <postgresuser> -d <databasename> -a -f server/database/schema.sql