Postgresql tables disappeared at Business Model

Question

I have a new data source as Postgresql 12.  Tables could be added at "Dataset" as queries but I can't see the schemas and tables being shown in the business model page.  There are only 3 tables being shown there: new_table_source, newtable, newtable_bkp.
 

I am sure whether I have done anything wrong.  The JDBC of Postgresql is version 42.2.1.   Does anyone provide clues to solve the issue?  Thanks in advance.

Comments

Hi absolutemusik,

can you upload a screenshot of your current situation?

Thank you,
Marco.

Answer 1

Thanks for your reply.
Actually, I have just found that I should add the current schema in the connection string to see the tables under 1 schema.
jdbc:postgresql://172.16.20.33:5432/wwxdb?currentSchema=dw

However, if I have 2 schema DW (data warehouse) and DM (data mart), it is likely not possible with the settings.

Comments

You may consider creating two different connections, one for each schema.