[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]

Originally Posted by 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.

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_schema

Expand|Select|Wrap|Line Numbers

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

Is it what you are looking for?