Working with PostgreSQL schemas

[filipgl]

Hello,

I would like to ask for help regarding the usage of PostgreSQL schemas. I have a sample database whose structure contains two additional schemas besides the default public schema. When I use the following code:

import Knex from "knex";
import schemaInspector from "knex-schema-inspector"

const database = Knex({
    client: "postgres",
    connection: {
        host: "localhost",
        port: 5432,
        user: "postgres",
        password: "1234",
        database: "example_eCommerce",
    },
});

const inspector = schemaInspector(database);

async function main(): Promise<void> {
    console.log(await inspector.tables())

    await database.destroy();
}

main();

Only tables of the public schema are printed. I know there is a withSchema method that can be used to set schema for inspector instance, but this approach is not very useful when schemas are unknown. Is there any way to get information about schemas of PostgreSQL database?