Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement