pandas-rs is oirginally designed for RedShift but also works for PostgreSQL. Inspired by pandas-td
I may should have made the package name as pandas-pg, since It also works for PostgreSQL.
To connect PostgreSQL and RedShift, you have to have the PostgreSQL client.
brew update brew install postgresql
pip install pandas-rs
As I mentioned, above pandas-rs works for PostgreSQL as well. First export password via shell(recommended)
import pandas_rs as rs import os # use only if you will access password through environment variables rs.create_engine( dbname='dev', user='test', password=os.environ['REDSHIFT_OR_POSTGRESQL_PASSWORD'], host='foobar.redshift.exmple', port='5439' ) print(rs.read_sql("""select 'hello PostgreSQL or redshift' greeting"""))
greeting 0 hello PostgreSQL or redshift