Psycopg APIs are a set of methods provided for users. This section describes some common APIs.
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()