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' '''

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