Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Identify the DDL of a postgresql table using talend

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?

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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