Identify the DDL of a postgresql table using talend

[Anonymous]

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?

[Anonymous · Accepted solution]

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