Inserting Data Into a PostgreSQL Database

You will notice that we have three variables in our statement: table, columns, and values. These thus become the parameters with which the function is called:

def insert(table, columns, values):

We should, of course, follow that with a doc string:

'''Function to insert the form data 'values' into table 'table' according to the columns in 'column' '''

• 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