Inserting Data Into a PostgreSQL Database

While some SQL insertion formats allow for understood or unstated column structure, we will be using the following template for our insert statements:

INSERT INTO <table> (columns) VALUES (values) ;

While we could pass a statement in this format to the psycopg method 'execute' and so insert data into the database, this quickly becomes convoluted and confusing. A better way is to compartmentalize the statement separately from the 'execute' command as follows:

statement = 'INSERT INTO ' + table + ' (' + columns + ') VALUES (' + values + ')'
mark.execute(statement)

In this way, form is kept separate from function. Such separation often helps in debugging.

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