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= >
    .