from urllib import parse
import pandas as pd
from sqlalchemy import create_engine


def getConn():
    host = 'xx.xx.xx.xx'
    user = 'postgres'
    password = parse.quote_plus('xx!@7xxx')
    database = 'xxx'
    post = '5432'
    return create_engine(f"postgresql+psycopg2://{user}:{password}@{host}:{post}/{database}")


if __name__ == '__main__':
    conn = getConn()

    sql3 = '''select * from xxxx limit 200'''

    df = pd.read_sql(sql3, con=conn)

    df.to_sql(name='code_temp', schema='public', con=conn, if_exists='append', index=False)