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.

• 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