PostgreSQL - Insert Data Into a Table using Python

In this article we will look into the process of inserting data into a PostgreSQL Table using Python. To do so follow the below steps:

• Step 1: Connect to the PostgreSQL database using the connect() method of psycopg2 module.

conn = psycopg2.connect(dsn)

• Step 2:  Create a new cursor object by making a call to the cursor() method

cur = conn.cursor()

• Step 3: Now execute the INSERT statement by running the execute() method

cur.execute(sql, (value1,value2))

• Step 4: After inserting the data call the commit() method to make the changes permanent.

conn.commit()

• Step 5: Now terminate the cursor and the connection to the database.

cur.close()
conn.close()

Example:

For example we will use the Student table of the school database that we created in the earlier sections of the article series.

Here we will create a insert_student() function to insert student_name row to the student table:

Now to verify the insertion use the following command in the psql shell:

SELECT * FROM student;

Output: