conn = psycopg2.connect("dbname='DBNAME' user='USER' host='HOST'
password='PASSWORD'")

insert = "INSERT INTO TABLE (COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5)
VALUES"

if len(gravar) >0 :
    cur = conn.cursor()
    y = b','.join(cur.mogrify("
(%s,%s,%s,%s,%s)", x) for x in gravar)
    comando = insert + y.decode()
    try:
        cur.execute("TRUNCATE TABLE TABLE")
        cur.execute(comando)
        conn.commit()
except (Exception, psycopg2.DatabaseError) as error:
    print(error)

cur.close()
print('Carga Completa')
else:
conn.close()
print('Nada a Inserir')