Quick Start PostgreSQL

== Create a Database

/opt/postgres/9.2/bin $ ./createdb -U postgres mydb
Password:

== Destroy the Database

/opt/postgres/9.2/bin $ ./dropdb mydb
Password:
dropdb: could not connect to database template1: FATAL: password authentication failed for user “jinny”
/opt/postgres/9.2/bin $ ./dropdb -U postgres mydb
Password:

== Accessing a Database

/opt/postgres/9.2/bin $ ./psql -U postgres mydb
Password:

== To get out of psql

mydb=# \q