Postgresql Basic Operation on Mac OSX


Installation

brew install postgres

Initiation

initdb /usr/local/var/postgres

Create User

createuser --pwprompt my_user

my_user is the username.

Create Database

createdb -Omy_user -Eutf8 my_database
  • my_user is the username, and the owner of the database.
  • my_database is the db name.

Entering DB console

psql -U my_user -W my_database

Done!