PostgresSQL
需要下载PostgreSQL;
本地安装时需要设置密码;
操作方式几乎与SQLlite3相同,需要引入psycopg2;
#sqlite3 #SQLlite 文件形式储存——易移植 pythonlibrary 中就有,无需西再
#psycopg2 #postSQL 需要下载postSQL才能打开,适合网络app的服务器使用
#import sqlite3
import psycopg2
#1.Connect to a database
#2.Create a Cursor object
#3.write an SQL query
#4.commit changes
#5.close the connection
def create_table():
conn = psycopg2.connect("dbname='database1' user='postgres' password='COco315500' host='localhost' port='5432'")
cur = conn.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS store (item TEXT, quantity INTEGER, price REAL)") #REAL是float
conn.commit(