Guest User

Untitled

a guest
Jun 14th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import psycopg2
  2.  
  3. def main():
  4. conn_string = "host= '%s' port = '%s' dbname= '%s' user= '%s' password= '%s'" % (localhost, "8080", "livin_tokyo", "tokyo", "kyoto")
  5. conn = psycopg2.connect(conn_string)
  6. dict_cur = conn.cursor()
  7.  
  8. sql = """SELECT id as num, name as irum, age, address as juso, salary as don
  9. FROM company
  10. ORDER BY id"""
  11. dict_cur.execute(sql)
  12. rows = dict_cur.fetchall()
  13. for row in rows:
  14. print("%s-year-old %s lives at %s and get paid %s every month" % (row[2], row[1], row[3], row[4]))
  15.  
  16. if __name__ == "__main__":
  17. main()
Add Comment
Please, Sign In to add comment