Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
A_BASSO
Contributor
Contributor

Can't get schemas inside my postgres database

Hi,

I'm new to the Talend universe and I try to use it for migrating data from one postgres DB to another one the problem is that my new one has multiple schema (other then the public one) and when I create a connection to my database I can get all the tables insides all schemas, but when I want to use one of those table, the schema metadata property in the component is empty and every time I want to use a table I've to click the component go inside the component tab click on the schema case say I want to switch to build-in mod and then set a value for the schema metadata, without that I will get an error saying the my table (for exemple user do not exist).

Am I doing something wrong? Is they-re a way to do it more efficiently?

Regards.

Labels (2)
1 Solution

Accepted Solutions
A_BASSO
Contributor
Contributor
Author

I somehow find a way to handle my problem it was a real pain in the a** so I write it here if someone someday encounter the same problem.

my solution is simply to create a db connection for each schema on the database and organise them by database inside folder

View solution in original post

1 Reply
A_BASSO
Contributor
Contributor
Author

I somehow find a way to handle my problem it was a real pain in the a** so I write it here if someone someday encounter the same problem.

my solution is simply to create a db connection for each schema on the database and organise them by database inside folder