Postgres sketches

gistfile1.txt

# Install
# http://postgresapp.com/
# http://postgresapp.com/documentation/cli-tools.html

DROP USER <username>;
CREATE USER <username> WITH PASSWORD '<password>';
CREATE DATABASE <database-name>;
GRANT ALL privileges ON DATABASE <database-name> TO <username>;

# Create DB
createdb <dbname>

# Drop DB
dropdb <dbname>

# Create dump
pg_dump -U <user> -h <host> <dbname> -f dump.sql

# Restore dump
psql -U postgres -d <dbname> -f <path_to_dump>