...
CLAIMS Direct PostgreSQL Role
CLAIMS Direct requires the role alexandria:
psql -Upostgres postgres |
Creating the Database
The PostgreSQL data warehouse portion of CLAIMS Direct is delivered in two parts:
- PostgreSQL database schema (alexandria-dwh.sql)
- <table>.gz files located in the sub-directory data
...
The following code block outlines the loading of the CLAIMS Direct data into PostgreSQL tables:
...
Code Block |
---|
...
# for |
...
each table, load ... |
...
gunzip -c data/<table>.gz | psql -Ualexandria |
...
# sample batch script
...
alexandria # sample batch script for tbldata in $(ls data/*.gz); |
...
do gunzip -c $tbldata | psql -Ualexandria alexandria |
...
done |
Creating the Credentials Database for CDWS
Coming soon: SQL package, installation, and population instructions