Skip to content

getTables crashes on loading #8

Description

@dfioravanti

The getTables function @adminjs/sql/lib/dialects/postgres.parser.js:82 is crashing because it tries to query the information schema with the following query

SELECT table_name
FROM information_schema.tables
AND table_type='BASE TABLE';

which is not a valid SQL query. I am not sure what the actual query is supposed to be. I tried to change it to

SELECT table_name
FROM information_schema.tables
WHERE table_schema='${schemaName}'

but it hangs. Any idea?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions