Re: [GENERAL] [SQL] How to Get Column Names from the Table

[Sreelatha G]

Hi,

To get column names only

 select column_name from information_schema.columns where
table_name='captor_prime_aggregates';

Thanks
Sreelatha
On Wed, Jul 7, 2010 at 2:44 PM, Viktor Bojović <viktor.bojo...@gmail.com>wrote:

> \d tableName
>
>
> On Wed, Jul 7, 2010 at 11:08 AM, venkat <ven.tammin...@gmail.com> wrote:
>
>> Dear All,
>>
>>    How to get Column Names from Table in PostgreSQL.
>>
>> Thanks and Regards,
>>
>> Venkat
>>
>
>
>
> --
> ---------------------------------------
> Viktor Bojović
> ---------------------------------------
> Wherever I go, Murphy goes with me
>