How Python operates the PgSQL database

This article mainly shows you "how Python operates PgSQL database", the content is simple and easy to understand, clear organization, I hope to help you solve doubts, let Xiaobian lead you to study and learn "how Python operates PgSQL database" this article bar.

1. Python operation PgSQL requires installing dependency package psycopg2 first.

#install dependencies pip3 install psycopg2

2. Use connect() in psycopg2 to connect to the database and create database connection objects and cursor objects.

Once the cursor object is obtained, SQL can be executed and the database manipulated.

import psycopg2 #Get connection object # database: database name # user: username # password: password # host: database ip address # port: port number, default is 5432conn = psycopg2.connect(database="db_name", user="postgres", password="pwd", host="127.0.0.1", port="5432") #Get cursor object cursor = conn.cursor() The above is all the content of "How Python operates PgSQL database", thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!