Insert, Update, Delete

Insert

import psycopg2

try:
    conn = psycopg2.connect(host="",database="", user="", password="")
except:
    print ("I am unable to connect to the database")

cursor = conn.cursor()

postgres_insert_query = """INSERT INTO db (name1, name2) VALUES (%s,%s)"""
record_to_insert = ('name1','name2')
cursor.execute(postgres_insert_query, record_to_insert)
conn.commit()


cursor.close()
conn.close()