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

From: Sreelatha G <sreetlatha(at)gmail(dot)com>
To: venkat <ven(dot)tammineni(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] How to Get Column Names from the Table
Date: 2010-07-07 10:12:23
Message-ID: AANLkTilsjTAXyN5DghR3M2U4c8w48UVxhov4-8igMpd1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message venkat 2010-07-07 10:14:07 Re: [SQL] How to Get Column Names from the Table
Previous Message Denis Gasparin 2010-07-07 09:32:53 Odd behaviour in update rule

Browse pgsql-sql by date

  From Date Subject
Next Message venkat 2010-07-07 10:14:07 Re: [SQL] How to Get Column Names from the Table
Previous Message Jayadevan M 2010-07-07 09:29:46 Re: How to Get Column Names from the Table