Skip to content

Instantly share code, notes, and snippets.

@jakebrinkmann

jakebrinkmann/connect_psycopg2_to_pandas.py

Created July 3, 2017 14:19
Show Gist options
  • Save jakebrinkmann/de7fd185efe9a1f459946cf72def057e to your computer and use it in GitHub Desktop.
Save jakebrinkmann/de7fd185efe9a1f459946cf72def057e to your computer and use it in GitHub Desktop.
Download ZIP
Read SQL query from psycopg2 into pandas dataframe
Raw
connect_psycopg2_to_pandas.py
import pandas as pd
import pandas.io.sql as sqlio
import psycopg2
conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = sqlio.read_sql_query(sql, conn)
conn = None
@dss010101
Copy link

does anyone now if pd.read_sql blocks? im have a multi-thread process that uses it, and it seems to block

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment