EHRBase DB: Where the data actually stored in the PG database

Implementation Platform
1

For EHRBase v2.6.0, where the data actually stored in the PG database?
I have several OPT templates and Compositions stored in the EHRBase’s PG database.

Out of curiosity, I’d like to take a look at the data, to figure out what they look like. So, I want to know what databases and database tables this data actually reside in? Also, what level of database permissions do I need to have for this?

Thanks.

2

Go to the ehr schema. The compositions are located in the comp_data table.

The “standard” db users of EHRbase should be sufficient to access the data.

1 Like
3

Thanks a lot, Birger. :heart: