Guest User

Untitled

a guest
Jul 31st, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. import psycopg2 as pg_driver
  2. db = pg_driver.connect(user=var_user, password=var_password, host=var_host,
  3. port=var_port)
  4. cursor = db.cursor()
  5. sql_query = ("""select *
  6. from asset_dhcp
  7. where id = 1""")
  8. cursor.execute(sql_query)
  9. result = cursor.fetchall()
  10. db.close()
  11. print(result)
  12.  
  13. [(1L, '00:50:56:ba:50:16', 131772604591350070L)]
Add Comment
Please, Sign In to add comment