1. conda create -n dbms python=3.4 pip
2. source activate dbms
3. pip install -r requirements.txt

### open python shell
1. import psycopg2
2. conn = psycopg2.connect(dbname="mydb", user="myuser", password="mypass",host="localhost")
3. cur = conn.cursor()
4. cur.execute("CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);")
5. cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)",(100, "abc'def"))
6. conn.commit()