def read_data(): #读 import psycopg2 import pandas as pd conn = psycopg2.connect(database='', user="", password="", host="", port="5432") cur = conn.cursor() cur.execute('select * from "db_name"') columns = [column[0] for column in cur.description] d = cur.fetchall() df = pd.DataFrame(d, columns=columns) conn.commit() conn.close() return df def write_data(): #写 from sqlalchemy import create_engine import pandas as pd db_engine = create_engine('postgresql://name:psd@ip:5432/db_name') df = pd.DataFrame() df.to_sql('table', db_engine, if_exists='append', index=False)
postgresql-python读写方法
最新推荐文章于 2023-04-19 08:45:00 发布