Skip to content

Instantly share code, notes, and snippets.

@ZhipengHe

ZhipengHe/mimiciv-ed.ps1

Last active January 31, 2023 01:42
Show Gist options
  • Save ZhipengHe/dc7acd2f85ba07350a5d74dd270a663c to your computer and use it in GitHub Desktop.
Save ZhipengHe/dc7acd2f85ba07350a5d74dd270a663c to your computer and use it in GitHub Desktop.
Download ZIP
Load MIMIC-ED to PSQL
Raw
mimiciv-ed.ps1
# change path
cd ~\Downloads\mimic-iv-ed\buildmimic\postgres
# create schemas and tables
psql -U postgres -d mimiciv -f .\create.sql
psql -U postgres -d mimiciv -v mimic_data_dir='C:\Users\n10599070\Downloads\mimic-iv-ed-2.2\ed' -v ON_ERROR_STOP=1 -f load_gz.sql
psql -U postgres -d mimiciv -f .\index.sql
psql -U postgres -d mimiciv -f .\constraint.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment