Also it's important to note that the schemas for the modules you enable
get created in the "folio" database, not the "okapi" database.

On 6/27/19 8:17 AM, Brandon Tharp wrote:
> To list all schemas:
>
> #connect to db
> \c okapi_modules
>
> #display all schemas
> \dn
>
> #display all schemas and their tables
> \dt *.*
>
> #display the contents of a schema and table
> Select * from <schema_name>.table;
>
> #Example:
> select * from diku_mod_users.users;
>
> Brandon Tharp | Systems Administrator III
> Digital Initiatives | Texas A&M University Libraries
> Tel. 979.458.5760 | Fax 979.845.6238
>
> On 6/27/19, 4:54 AM, "sysops-sig@ole-lists.openlibraryfoundation.org on behalf of Zeno Tajoli" <sysops-sig@ole-lists.openlibraryfoundation.org on behalf of zeno.tajoli@atcult.it> wrote:
>
>      Hi to all,
>
>      with Vagrant and VirtualBox I create a working Folio Core
>      [https://urldefense.proofpoint.com/v2/url?u=https-3A__app.vagrantup.com_folio_boxes_Q1-2D2019&d=DwIDbA&c=u6LDEWzohnDQ01ySGnxMzg&r=4lxuYo8mSwR6LFiJmpt0tz6YkGMgoHBIMDSChCOdpSk&m=blphq8J_LPYcuOBuFZryrRh7IODUxTMEyPYUIMar4iA&s=iNR3zijV01-s1si5GUDyhEJinXX-xVgk6X1nE3AhqD8&e= ]
>
>      As I know the storage of data is inside PostgreSQL.
>      I find two db: 'okapi' and 'okapi_modules'
>
>      Into 'okapi_modules' I don't find any table.
>      Into 'okapi' I find:
>      deployments
>      env
>      modules
>      tenants
>
>      Inside them I find only general setup data.
>      Do you know where I need to seek data ?
>      Do you have any tip on PostegreSQL and Folio ?
>
>      Cheers
>      Zeno Tajoli
>
>      --
>      Zeno Tajoli
>      System Librarian
>
>      @CULT Srl
>      Via Quintino Sella, 33 - 00187 Roma
>      Tel +39 06 89873504 - Fax +39 06 89873496
>      zeno.tajoli@atcult.it
>
>      https://urldefense.proofpoint.com/v2/url?u=http-3A__www.atcult.it&d=DwIDbA&c=u6LDEWzohnDQ01ySGnxMzg&r=4lxuYo8mSwR6LFiJmpt0tz6YkGMgoHBIMDSChCOdpSk&m=blphq8J_LPYcuOBuFZryrRh7IODUxTMEyPYUIMar4iA&s=bTPMmUxmRKbtuQS3dIr757yQeRtlHLmUm8dxIJyiUIM&e=
>
>      Questo messaggio è destinato alle sole persone indicate e può contenere
>      informazioni riservate.
>      Ogni altro uso del messaggio è vietato. Se avete ricevuto questa e-mail
>      per errore, siete pregati
>      di cancellare l'originale e comunicarcelo immediatamente via e-mail
>      all'indirizzo info@atcult.it
>
>      ------------------------------------------------------
>      You received this message because you are subscribed to OLE Mailing List
>      "sysops-sig".
>      To unsubscribe from this list and stop receiving emails from it, follow
>      this link: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.simplelists.com_confirm.php-3Fu-3DYqPVWK1HxxWxsYYSLtSEYuWrm7FNkoOL&d=DwIDbA&c=u6LDEWzohnDQ01ySGnxMzg&r=4lxuYo8mSwR6LFiJmpt0tz6YkGMgoHBIMDSChCOdpSk&m=blphq8J_LPYcuOBuFZryrRh7IODUxTMEyPYUIMar4iA&s=9H0hw1iAMAaNUNA0I2LUsls3uXudA4DSLBBLneW74f8&e= .
>      To post to this group, send email to
>      sysops-sig@ole-lists.openlibraryfoundation.org
>      <mailto:sysops-sig@ole-lists.openlibraryfoundation.org>.
>      Visit this group at
>      https://urldefense.proofpoint.com/v2/url?u=https-3A__ole-2Dlists.openlibraryfoundation.org&d=DwIDbA&c=u6LDEWzohnDQ01ySGnxMzg&r=4lxuYo8mSwR6LFiJmpt0tz6YkGMgoHBIMDSChCOdpSk&m=blphq8J_LPYcuOBuFZryrRh7IODUxTMEyPYUIMar4iA&s=WYF35_DLEXE0AYifIiOUdAFsq5a_Lq-eA4Nb44L3o78&e= <https://urldefense.proofpoint.com/v2/url?u=https-3A__ole-2Dlists.openlibraryfoundation.org&d=DwIDbA&c=u6LDEWzohnDQ01ySGnxMzg&r=4lxuYo8mSwR6LFiJmpt0tz6YkGMgoHBIMDSChCOdpSk&m=blphq8J_LPYcuOBuFZryrRh7IODUxTMEyPYUIMar4iA&s=WYF35_DLEXE0AYifIiOUdAFsq5a_Lq-eA4Nb44L3o78&e= >
>      .
>
>
> ------------------------------------------------------
> You received this message because you are subscribed to OLE Mailing List
> "sysops-sig".
> To unsubscribe from this list and stop receiving emails from it, follow
> this link: http://www.simplelists.com/confirm.php?u=WKkzXsEEIuBoS0XdiNvB7Cq7H598eXi1.
> To post to this group, send email to
> sysops-sig@ole-lists.openlibraryfoundation.org
> <mailto:sysops-sig@ole-lists.openlibraryfoundation.org>.
> Visit this group at
> https://ole-lists.openlibraryfoundation.org<https://ole-lists.openlibraryfoundation.org>
> .

--
Christopher Creswell
Library and Technology Services
Sr. Library Systems Analyst
(610) 758-1432
ccc2@lehigh.edu