how to list columns from table

[Anonymous]

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

[vapukov]

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