how to list columns from table

Anonymous — Mon, 06 Mar 2017 17:42:35 GMT

Hi,
I have requirement to list columns from table. Currently i am using tJDBCColumnList(DB Type : Postgresql) but it is not giving correct result.
For other DB Types its working well. Can you please help me with any other descriptor.

Regards
Prasoon

Re: how to list columns from table

vapukov — Tue, 07 Mar 2017 01:29:17 GMT

depending from what You really need, You always can request it self from database
for postgresql it will be :

SELECT 
	"column_name", 
	"udt_name"
FROM information_schema.columns
WHERE table_schema = 'your_schema'
  AND table_name   = 'your_table'

component - tPostgresqlRow
You can add some other columns if You need

topic Re: how to list columns from table in Talend Studio

how to list columns from table

Re: how to list columns from table