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

**Category:** [Platform](https://discourse.openehr.org/c/platform-implem/7)
**Created:** 2024-08-21 06:54 UTC
**Views:** 85
**Replies:** 2
**URL:** https://discourse.openehr.org/t/ehrbase-db-where-the-data-actually-stored-in-the-pg-database/5591

---

## Post #1 by @linforest

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.

---

## Post #2 by @birger.haarbrandt

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.

---

## Post #3 by @linforest

Thanks a lot, Birger. :heart:

---


**Canonical:** https://discourse.openehr.org/t/ehrbase-db-where-the-data-actually-stored-in-the-pg-database/5591
**Original content:** https://discourse.openehr.org/t/ehrbase-db-where-the-data-actually-stored-in-the-pg-database/5591