import psycopg2
conn = psycopg2.connect(database="ET", user="guillaume")
cursor = conn.cursor()

# cursor.execute("select select a.name,a.issuername,a.loanxid,b.bid from et_collateral a left outer join markit_prices b on a.loanxid=b.loanxid where a.dealname='octagon8'")
cursor.execute("select a.name, COALESCE(b.bid,c.price) as price, a.currentbalance from et_collateral a left outer join markit_prices b on a.loanxid=b.loanxid left outer join bloomberg_prices c on a.cusip=c.cusip where a.dealname='octagon8'")

for line in cursor:
    # import pdb;pdb.set_trace()
    print  "\t".join(map(str,line))
cursor.close()
conn.close()