gistfile1.py

import psycopg2
import os, sys
import csv
import code

queryfile = sys.argv[1]
args = sys.argv[2:]

query = open(queryfile).read()

connectionstring = open(os.path.expanduser('~/socorro.connection'), 'r').read().strip()

conn = psycopg2.connect(connectionstring)
cur = conn.cursor()

print "Connection available as `conn`"
print "Cursor available as `cur`"

code.interact(local=locals())