on a table

[sasimca007]

Hello friends,
May i know how to know the column names of a table in postgresql. I am expecting through query. I have to apply that query in modperl.

[rski]

Hello friends,
May i know how to know the column names of a table in postgresql. I am expecting through query. I have to apply that query in modperl.

To be clear, you need to find a query wich show you column names in a given table. If so you can do it for example using information_sch ema

select column_name from information_schema.columns where table_name='put here the table name';

Is it what you are looking for?