postgres_connect_py

arguments = {'user': 'postgres',
             'pwd': 'password',
             'host': 'localhost',
             'port': 5432,
             'db': 'db_name'}
connection_string = 'postgresql://{}:{}@{}:{}/{}'.format(arguments['user'],
                                                         arguments['pwd'],
                                                         arguments['host'],
                                                         arguments['port'],
                                                         arguments['db'])

engine = create_engine(connection_string)
query = ''' SELECT *
                FROM bd_table
            '''
df = pd.io.sql.read_sql(query, con = engine, index_col = 'id')