postgis数据库导出csv表再导入postgis

GIS从业者

于 2023-09-01 11:28:19 发布

阅读量828

点赞数

分类专栏： MySQL、postgresq、MongoDB、Redis 文章标签：数据库

本文链接：https://blog.csdn.net/yilvyangguang520/article/details/132620339

版权

MySQL、postgresq、MongoDB、Redis 专栏收录该内容

64 篇文章 2 订阅

订阅专栏

1、导出csv表

from settings_Address import *
from sqlalchemy import create_engine, MetaData
import pandas as pd
def create_conn(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG):
    # return create_engine('Postgis+pyPostgis://{}:{}@{}:{}/{}'.format(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG))
    return  create_engine('postgresql://{}:{}@{}:{}/{}'.format(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG))


def save_csv(table_name):
    # 建立连接
    conn=create_conn(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG)
    query = "SELECT * FROM {}".format(table_name)
    df = pd.read_sql_query(query, conn)
    df.to_csv("./data/"+table_name+".csv", index=False)
    print("导出数据成功：","./data/"+table_name+".csv")

if __name__ == "__main__":
    save_csv("smssencoding")