import psycopg2
engine = sqlalchemy.create_engine('postgresql+psycopg2://...')
the_frame = pd.read_sql_query('SELECT * FROM %s;' % name_of_table, engine)
the_frame = pd.read_sql_table(name_of_table, engine)
Getting data from table in database