Quick Bootstrap

This is a copy of the source env variables you can run if you have installed Postgres

Run the commented out comments once and save this as $YOURNAME_ENV_.sh for the project and do not commit it.

export OKC_DB_NAME=okcandidate_dev
export OKC_DB_USER=okcandidate
export OKC_DB_PASSWORD=code4hr
# Run the below once
# psql -d okcandidate_dev -a -f okcandidate_database_create.sql
# psql -d okcandidate_dev -a -f okcandidate_database_sampledata.sql
# psql
# CREATE USER okcandidate WITH PASSWORD 'code4hr';
# CREATE DATABASE okcandidate_dev;
# GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public to okcandidate;
# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO okcandidate;

also on ubuntu you can use # as sudo -u postgres psql