# Access a running docker container of the the database

**URL:** <https://talk.openelis-global.org/t/access-a-running-docker-container-of-the-the-database/681>\
**Category:** GSOC\
**Tags:** dev\
**Created:** [April 1, 2024, 9:45am UTC](https://talk.openelis-global.org/t/access-a-running-docker-container-of-the-the-database/681 "2024-04-01T09:45:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mherman22](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/mherman22/32/92_2.png) [@mherman22](https://talk.openelis-global.org/u/mherman22)\
**Post date:** [April 1, 2024, 9:45am UTC](https://talk.openelis-global.org/t/access-a-running-docker-container-of-the-the-database/681/1 "2024-04-01T09:45:26Z")

</div>

Hey @Moses_Mutesasira i am trying to access the running instance of the database (postress - **clinlims** ) using this command `docker exec -it openelisglobal-database psql -U postgres` and it’s perfectly doing what i expect it to do.

However my challenge on actually viewing all the tables within the database, when i execute `\dt` i get this as the result → _ **Did not find any relations.** _.

Could i be doing anything wrongly?

---

<div class="post-metadata">

**Author:** ![mherman22](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.openelis-global.org/mherman22/32/92_2.png) [@mherman22](https://talk.openelis-global.org/u/mherman22)\
**Post date:** [April 1, 2024, 9:50am UTC](https://talk.openelis-global.org/t/access-a-running-docker-container-of-the-the-database/681/2 "2024-04-01T09:50:42Z")

</div>

(I guess i shouldn’t delete this since i have got the fix immediately after posting)

I will just go ahead and provide the solution

Apparently **\dt** will only list relations that are present in the default schema which is public hence the resulting _ **Did not find any relations** _ since public has no relations.

So i needed to SET search\_path to **clinlims** , after that, it will list all relations present in schema clinlims.

```auto
postgres=# show search_path;
   search_path   
-----------------
 "$user", public
(1 row)

postgres=# set search_path="clinlims";
SET

postgres=# show search_path;

 search_path 
-------------
 "clinlims"
(1 row)

```

Hence the the tables below (in screenshot)

 ![Screenshot from 2024-04-01 12-49-42](https://canada1.discourse-cdn.com/flex030/uploads/openelisci/original/1X/22fbe2fd54d9b614fc8cd5dd4ab2ff7e6bfb67d1.png)