topic Re: How to move all table with data from one schema to another schema in PostgreSQL using talend in Talend Studio

How to move all table with data from one schema to another schema in PostgreSQL using talend

RAJ6 — Sat, 16 Nov 2024 08:45:20 GMT

Hi Folks,

How to move all table with data from one schema to another schema in PostgreSQL using talend job

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

TRF — Mon, 05 Feb 2018 08:43:36 GMT

Hi,

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.

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

RAJ6 — Mon, 05 Feb 2018 09:41:51 GMT

Hi TRF,

I have tried your solution but it's shows error. please find the error attached screenshots.

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

manodwhb — Mon, 05 Feb 2018 12:03:06 GMT

You have not specified Table,becuse of that you are getting job compilation error.

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

TRF — Mon, 05 Feb 2018 12:08:15 GMT

Table name is mandatory

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

RAJ6 — Mon, 05 Feb 2018 15:43:53 GMT

Hi TRF,

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?

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

TRF — Mon, 05 Feb 2018 16:59:16 GMT

Hi,

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:

https://stackoverflow.com/questions/18216462/how-to-duplicate-schemas-in-postgresql

https://dba.stackexchange.com/questions/10474/postgresql-how-to-create-full-copy-of-database-schema-in-same-database

Re: How to move all table with data from one schema to another schema in PostgreSQL using talend

TRF — Wed, 07 Feb 2018 08:57:11 GMT

Does this help?

If so, thank's to close the case by selecting the most usefull answer.
Kudos also accepted.