Skip to content

Instantly share code, notes, and snippets.

@Makesh

Makesh/PGPASSWORD

Created March 14, 2016 04:05
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 Makesh/df6b011c3322c76ee396 to your computer and use it in GitHub Desktop.
Save Makesh/df6b011c3322c76ee396 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PGPASSWORD
export PGPASSWORD=password
/Library/PostgreSQL/9.4/bin/psql -U postgres -f /Users/makesh/Documents/Workspace/medex/database/dbdrop.sql
echo "re-create database .. "
/Library/PostgreSQL/9.4/bin/psql -U postgres -f /Users/makesh/Documents/Workspace/medex/database/dbcreate.sql
echo "run dll database .. "
/Library/PostgreSQL/9.4/bin/psql -U postgres -d medx -f /Users/makesh/Documents/Workspace/medex/database/ddl.sql
echo "re-create procedures in database .. "
/Library/PostgreSQL/9.4/bin/psql -U postgres -d medx -f /Users/makesh/Documents/Workspace/medex/database/procedure.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment