insert into database query psycopg2
import psycopg2 conn = psycopg2.connect(host=pg_credential.hostname, port=pg_credential.port, user=pg_credential.username, password=pg_credential.password, database=pg_credential.path[1:]) # To remove slash cursor = conn.cursor() cursor.execute("INSERT INTO a_table (c1, c2, c3) VALUES(%s, %s, %s)", (v1, v2, v3)) conn.commit() # <- We MUST commit to reflect the inserted data cursor.close() conn.close()