PostgreSQL patient data

Hello, how do I query the PostgreSQL patient data, such as name, patient id, physician name, study number?

I realized that the data is all placed in the same list in the VALUE column.

How do I do ? Anybody know

First question: are you sure you don’t want to use the Rest API to get these data ? i.e, by calling the http://…/patients/{id} route ? (http://book.orthanc-server.com/users/rest.html)

You’re actually not supposed to access the DB directly (that’s the reason why the database schema is not really documented).