Skip to content

Instantly share code, notes, and snippets.

@ryandotclair

ryandotclair/setup-db.sh

Created December 9, 2015 05:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ryandotclair/e83511b5f8ef92546ce8 to your computer and use it in GitHub Desktop.
Save ryandotclair/e83511b5f8ef92546ce8 to your computer and use it in GitHub Desktop.
Download ZIP
setup-db.sh
Raw
setup-db.sh
#! /bin/bash
psql --username "$POSTGRES_USER" -c "create database reporter;"
psql --username "$POSTGRES_USER" -d reporter -c "create schema reporterschema;"
psql --username "$POSTGRES_USER" -d reporter -c \
"create table reporterschema.main(Key BIGSERIAL PRIMARY KEY,Date DATE NOT NULL,SN TEXT NOT NULL,SG TEXT NOT NULL,SRDFA_MBSent INT NOT NULL);"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment