Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a use case where I have to copy the DDL of a postgresql table into file. Any idea how I can do that through talend?
Hi,
I am not sure of the command PostgreSQL is using to generate the DDL for a table. You may have to browse through PostgreSQL forums to get this information. Anyway, once you have the query handy, you can either use tDBInput or tDBRow component to run those SQL queries in Talend to write the information to file.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Hi,
I am not sure of the command PostgreSQL is using to generate the DDL for a table. You may have to browse through PostgreSQL forums to get this information. Anyway, once you have the query handy, you can either use tDBInput or tDBRow component to run those SQL queries in Talend to write the information to file.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved