# Help on how to get datasets

**URL:** <https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573>\
**Category:** Community\
**Tags:** dev\
**Created:** [June 9, 2025, 7:16pm UTC](https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573 "2025-06-09T19:16:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ariho-Seth](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/ariho-seth/32/1278_2.png) [@Ariho-Seth](https://talk.openelis-global.org/u/Ariho-Seth)\
**Post date:** [June 9, 2025, 7:16pm UTC](https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573/1 "2025-06-09T19:16:35Z")

</div>

Greetings @Moses_Mutesasira @Agaba_Derrick_Junior @mherman22. I would like to be helped on how to get datasets, the xml data for different test services.  
I’m currently writing integration tests for the TestReflexService though I would like to have the datasets to continue with the tests  
Thanks for your help.

---

<div class="post-metadata">

**Author:** ![Agaba\_Derrick\_Junior](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/agaba_derrick_junior/32/503_2.png) [@Agaba\_Derrick\_Junior](https://talk.openelis-global.org/u/Agaba_Derrick_Junior)\
**Post date:** [June 10, 2025, 8:08am UTC](https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573/2 "2025-06-10T08:08:14Z")

</div>

@Ariho-Seth for started you need to know how to access the database, i.e using terminal

> docker exec -it openelisglobal-database psql -U clinlims -d clinlims

in other ways you can use dbeaver-ce a database app or log In Postgress SQL and access our db

For selecting what tables you are working on you can use /d and the name of the table you are searching it will always list the table information

---

<div class="post-metadata">

**Author:** ![Agaba\_Derrick\_Junior](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/agaba_derrick_junior/32/503_2.png) [@Agaba\_Derrick\_Junior](https://talk.openelis-global.org/u/Agaba_Derrick_Junior)\
**Post date:** [June 10, 2025, 8:19am UTC](https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573/3 "2025-06-10T08:19:02Z")

</div>

@Ariho-Seth take note of how some table names are written, some names are written with underscores(\_) and there fore if you write them without underscores they wont showup  
useful commands while searching  
`SELECT * FROM table_name;` – Get all data from a table.

- `\dt` – List all tables.
- `\d table_name` – Describe table structure (columns, types, indexes, etc.).
- `\dn` – List all schemas.
- `\dv` – List all views.
- `\df` – List all functions.
- `dt ` – Show tables across all schemas.
- `\d+ table_name` – Describe with additional details like storage and size.
- `SELECT * FROM information_schema.tables;` – Standard way to list tables.
- `SELECT * FROM pg_catalog.pg_tables WHERE tablename LIKE '%keyword%';` – Search tables by

this works while using terminal after logging in with

> docker exec -it openelisglobal-database psql -U clinlims -d clinlims

---

<div class="post-metadata">

**Author:** ![Ariho-Seth](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/ariho-seth/32/1278_2.png) [@Ariho-Seth](https://talk.openelis-global.org/u/Ariho-Seth)\
**Post date:** [June 10, 2025, 8:45am UTC](https://talk.openelis-global.org/t/help-on-how-to-get-datasets/1573/4 "2025-06-10T08:45:18Z")

</div>

Sure Thanks a lot for your help,