oshapio

import pickle
import psycopg2 as py

# Replace this with your mimic iii database details
conn = py.connect(
    "dbname = 'mimic' user = 'root' host = 'localhost' port='5432' password = 'postgres'")

cur = conn.cursor()
cur.execute("""select hadm_id from admissions""")
list_adm_id = cur.fetchall()