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
- Step 4: After inserting the data call the commit() method to make the changes permanent.
- Step 5: Now terminate the cursor and the connection to the database.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
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;