brew install postgresql
# To have launchd start postgresql now and restart at login
brew services start postgresql

# if you don't want/need a background service you can just run
pg_ctl -D /usr/local/var/postgres start

# Create database
createdb <database_name>
createdb mydjangoproject_development # example

# List databases
psql -U postgres -l

# Show tables in database
psql -U postgres -d <database_name>
psql -U postgres -d mydjangoproject_development # example

# Drop database
dropdb <database_name>
dropdb mydjangoproject_development # example

# Restart database
dropdb <database_name> && createdb <database_name>
dropdb mydjangoproject_development && createdb mydjangoproject_development # example