import psycopg2 as pg
import pandas as pd

conn = pg.connect(database="mydatabase",
                  user="myuser",
                  password="mypassword")

df = pd.read_sql('select * from event', conn)