简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > Python Tutorial > body text

How to connect to PostgreSQL database in Python

WBOY
Release： 2016-12-05 13:27:22
Original
2232 people have browsed it

Foreword

In fact, there are many modules that can be used to connect to PostgreSQL in Python, and psycopg2 is recommended here. psycopg2 is very simple to install (pip install psycopg2). Here we mainly focus on how to use it.

Connect to database: 

import psycopg2
conn = psycopg2.connect(host="10.100.157.168",user="postgres",password="postgres",database="testdb")
Copy after login

Available parameters when connecting:

dbname – database name (dsn connection mode)

database – database name

      user – username

password – password

Host – server address (if the default connection Unix Socket is not provided)

port – connection port (default 5432)

Execute SQL

import psycopg2
 
conn = psycopg2.connect(host="10.100.157.168",port=5432,user="postgres",password="postgres",database="testdb")
cur = conn.cursor()
sql = ""
cur.execute(sql)
conn.commit() # 查询时无需，此方法提交当前事务。如果不调用这个方法，无论做了什么修改，自从上次调用#commit()是不可见的
conn.close()
Copy after login

In addition, parameterization is supported when executing SQL

Syntax: cursor.execute(sql [, optional parameters])

Case: cursor.execute("insert into people values ​​(%s, %s)", (who, age))

Summary

The above is the entire content of this article. I hope the content of this article can bring some help to everyone's study or work. If you have any questions, you can leave a message to communicate.

Related labels：
postgresql python
source：php.cn
Previous article：python string, numerical calculation Next article：Flask framework study guide user login management
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to run python script from HTML in google chrome? I'm building a chrome extension and I want to run a python script from my PC by clicking a...
From 2023-11-02 23:34:24
0
1
400
Why do some mysql connections select old data of mysql database after delete+insert? I have a problem with sessions in my python/wsgiweb application. Each thread in the 2 wsgi...
From 2023-10-30 12:37:20
0
2
229
Using variables to execute SQL statements in Python I have the following Python code: cursor.execute("INSERTINTOtableVALUESvar1,var2,var3...
From 2023-10-12 15:06:00
0
2
258
Understanding the ternary operator in Python [duplicate] I'm currently transitioning from JavaScript to Python, and I'm wondering if Python has a t...
From 2023-09-21 18:46:04
0
1
377
How to match strings with appended parts using Python, but not match them if their appended parts are different How to match strings with appended parts, but not match them if they have different append...
From 2023-09-20 19:02:23
0
1
260
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！