Untitled Note
By: Anonymous2/3/202321 views Public Note
#sending data from python to postgresql
#python -> psql connection
import psycopg2
import psycopg2.extras
#create dataframes
import pandas as pd
conn = psycopg2.connect(
dbname="postgres",
user="postgres",
password="postgres",
host="localhost",
port="8888")# Connect to an existing database
#Create new_cursor allowing us to write Python to execute PSQL:
cur = conn.cursor()
#Read documentation understanding when to Use