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()

Index: Inserting Data Into a PostgreSQL Database

1. Psycopg: Install and Import
2. Python to PostgreSQL: Open Sesame
3. Mark Your Place in PostgreSQL With Python
4. Separating PostgreSQL Form and Python Function
5. Python, PostgreSQL, and the 'C' Word
6. Define the Parameters
7. Put it All Together And Call It