Identify the DDL of a postgresql table using talend

Anonymous — Sat, 16 Nov 2024 03:59:14 GMT

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?

Re: Identify the DDL of a postgresql table using talend

Anonymous — Thu, 28 Nov 2019 15:24:21 GMT

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

topic Re: Identify the DDL of a postgresql table using talend in Talend Studio

Identify the DDL of a postgresql table using talend

Re: Identify the DDL of a postgresql table using talend