postgres command memo - migrate here : https://github.com/VincentLoy/alzheimer

psql.md

Connect as root

$ sudo -u postgres psql

Create new user

postgres=# CREATE USER example WITH PASSWORD 'example';

Change user Password

postgres=# ALTER USER username WITH LOGIN PASSWORD 'new_password';

Grant the user

postgres=# GRANT ALL PRIVILEGES ON DATABASE example to example;

Add extensions

postgis is used as example

postgres=# CREATE EXTENSION IF NOT EXISTS postgis;

Inject an SQL Dump to an existing DB

$ psql your_db_name < /path/to/dump.sql

Postgres URL format

use the following template in every Django projects postgres://username:password@hostname/db_name

To quit just type \q