================== ====================================================================================
task postgresql
================== ====================================================================================
create database createdb mydb
------------------ ------------------------------------------------------------------------------------
command-line tool psql -d mydb
------------------ ------------------------------------------------------------------------------------
GUI tool pgadmin3
------------------ ------------------------------------------------------------------------------------
install module easy_install psycopg2
------------------ ------------------------------------------------------------------------------------
import from psycopg2 import *
------------------ ------------------------------------------------------------------------------------
connect conn = connect("dbname='testdb' user='me' host='localhost' password='mypassword'”)
------------------ ------------------------------------------------------------------------------------
get cursor curs = conn.cursor()
------------------ ------------------------------------------------------------------------------------
execute SELECT curs.execute('SELECT * FROM tbl')
------------------ ------------------------------------------------------------------------------------
fetch curs.fetchone(); curs.fetchall(); curs.fetchmany()
------------------ ------------------------------------------------------------------------------------
use bind variables curs.execute('SELECT * FROM tbl WHERE col = %(varnm)s', {'varnm':22})
------------------ ------------------------------------------------------------------------------------
commit conn.commit() (required)
------------------ ------------------------------------------------------------------------------------
