Public schema tables not visible in Posgress

Hello Team,

I am using postgres 15.6 with Helical Insight application and i am facing one issue. I have few tables into my PUBLIC schema but while creating a metadata i am not able to see those tables under PUBLIC schema. I can see the same under any 3rd party db client. How to fix this?

Thank you,
Snow.

Hello ,

Since you are having Postgres 15+ version, there are some different commands required to list down the list of schema, tables inside it.

In order to solve this, We have attached a file called “postgresql.efwd”, please deploy/replace this file at location “....\hi\hi-repository\System\Admin\DbConfig”. Once you deploy this, please clear the cache of Helical Insight application as well as web browser which you are using. This updated file will solve the issue and it will list down tables inside public schema.

postgresql.zip (832 Bytes)

Thank you,
Helical Insight.

Hi, we are having this issue in Cybira, but we can`t download file postgresql.efwd attached in the previosly post

Please try the postgresql.efwd file present in this zip file postgresql.zip (832 Bytes)