Inserting Data Into a PostgreSQL Database

From Al Lukaszewski, former About.com Guide

Finally, we have a function for inserting data into a table of our choice, using columns and values defined as needed.

 def insert(table, columns, values):
 '''Function to insert the form data 'values' into table 'table'
 according to the columns in 'column' '''
 
      connection = psycopg.connect('dbname=Birds', 'user=robert')
      mark = connection.cursor()
      statement = 'INSERT INTO ' + table + ' (' + columns + ') VALUES (' + values + ')'
      mark.execute(statement)
      connection.commit()
      return 

To call this function, we simply need to define the table, columns, and values and pass them as follows:

 type = "Owls"
 fields = "id, kind, date"
 values = "17965, Barn owl, 2006-07-16"
 
 insert(type, fields, values) 

Previous

• 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

Next