Inserting Data Into a PostgreSQL Database

Finally, after passing the data to PostgreSQL, we must commit the data to the database:

connection.commit()

Now we have constructed the basic parts of our function 'insert'. Put together, the parts look like this:

connection = psycopg.connect('dbname=Birds', 'user=robert')
mark = connection.cursor()
statement = 'INSERT INTO ' + table + ' (' + columns + ') VALUES (' + values + ')'
mark.execute(statement)
connection.commit()

• Psycopg: Install and Import
• Python to PostgreSQL: Open Sesame
• Mark Your Place in PostgreSQL With Python
• Separating PostgreSQL Form and Python Function
• Python, PostgreSQL, and the 'C' Word
• Define the Parameters
• Put it All Together And Call It