psycopg2: Python library for postgresql

import psycopg2 as pg

conn = pg.connect(dbname="", user="", password="", options="")

# Create cursor
cur = conn.cursor()

try:
	cur.execute("SELECT one, two FROM ...")

	# Safe insertion
	cur.execute("INSERT INTO ... VALUES (%s, %s, %s);", (v1, v2, v3))
	
	for (one, two) in cur:
		...

except pg.Error as ex:
	conn.rollback()

finally:
	cur.close()
  conn.commit()
  conn.close()