Database

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Installing PSequel

PSequel, a PostgreSQL GUI tool, provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.

Installing Postgres via Brew

Pre-Reqs

$ brew doctor
$ brew update

Installing

$ brew install postgresql

PostgreSQL Commands

Create database

createdb <database_name>

List databases

psql -U postgres -l

Show tables in database

psql -U postgres -d <database_name>

Drop database

dropdb <database_name>

Restart database

dropdb <database_name> && createdb <database_name>

Resources

• PostgreSQL: SQL Commands
• Github: PostgreSQL commands