================== ====================================================================================
              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)
------------------ ------------------------------------------------------------------------------------