Read from postgreSQL table into pandas dataframe using psycopg2 / sql query

connect_to_postgres_with_psycopg2_and_pandas.py

import pandas as pd
import pandas.io.sql as pdsql
import psycopg2


# Database connection details
creds = {
    "dbname": "mydb",
    "user": "jsmith",
    "password": "hello1234",
    "host": "database.hostname.company.com",
    "port": 5432,
    "sslmode": "require",
}

with psycopg2.connect(**creds) as conn:

    query = "select * from mytable limit 10;"

    df = pdsql.read_sql_query(query, conn)

    # If you have date columns to parse:
    # df = pdsql.read_sql_query(query, conn, parse_dates=["created_ts"])