Code validation not detecting Postgres tables

Could you please provide us with a full query you're trying to execute? With a sample Postgres database, I wasn't able to reproduce the problem.

Hi Olga,

that's the main problem. It does not depend on the query and also not on the schema.

await dbCon.queryDB(
    `UPDATE users.user_roles
          SET name = $1, description = $2, last_update_date = NOW(), last_update_by = $3
          WHERE id = $3`,
    [role.name, role.description, session.user.sso]);

does not work and

let response = await dbCon.queryDB(
    `SELECT name, description
          FROM modalities m`,
    null);
res.json(response.rows);

without giving an explicit schema does not work either.

It worked fine as long as I had only one schema and the schema name was "public" (What seems to be Postgres default schema if you create a new database). But when I removed the "public" schema and created the two new ones, none of them is recognized by Intelliji

Ok,

I finally found out, that if I set the Resolution Scope for only one file to the used schema it works. 

But is there no way to add a whole folder to the the scope? Its much work to set it for each file one by one.

Ok,

just removed all scopes, removed all datasources, added new datasource, added new default scope and now it works.

Some times you not not understand everything

Thanks for your help anyway

I'm happy it works fine now! 
Please, let me know if you have further questions or requests.