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

Dear Sreelatha.

It is working fine. Thanks alot.

Thanks and Regards,

Venkat

On Wed, Jul 7, 2010 at 3:42 PM, Sreelatha G <sreetlatha(at)gmail(dot)com> wrote:

> 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(dot)bojovic(at)gmail(dot)com>wrote:
>
>> \d tableName
>>
>>
>> On Wed, Jul 7, 2010 at 11:08 AM, venkat <ven(dot)tammineni(at)gmail(dot)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
>>
>
>