Hello Everyone!
I am trying to load data from all the database dynamically in postgres.
the idea is used to create one single connection and load the data from 130 DB . The table structure is same across all the DB . I have implemented this logic in MSSQL but couldnt do in postgres . We are using postgreSQL connector to connect to source where the DB name is must when creating the connection and can not pass the DB name .
Any idea how to achieve the same.
Thanks ,