How to move all table with data from one schema to another schema in PostgreSQL using talend job
This scenario should works.
tPostgresqlInput (source schema) --> tPostgresqlOutput (using a separate connection on target schema, Action on table = "Drop and creta table", Action on data = "Insert")
Does this helps.
I have tried your solution but it's shows error. please find the error attached screenshots.
You have not specified Table,becuse of that you are getting job compilation error.
Thank you folks.
In my schema have 60 tables. I can move table with data sources schema to designation schema one by one but I need to move all table using single talend job. whether its possible or not?
You cannot expect to do with Talend what you cannot do with a standard Postgresql command.
You may refer to these links for a work around:
Does this help?
If so, thank's to close the case by selecting the most usefull answer.
Kudos also accepted.