Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How to Get Column Names from the Table - Mailing list pgsql-sql

From Sreelatha G
Subject Re: [GENERAL] How to Get Column Names from the Table
Date
Msg-id AANLkTilsjTAXyN5DghR3M2U4c8w48UVxhov4-8igMpd1@mail.gmail.com
Whole thread Raw
In response to Re: How to Get Column Names from the Table  (Viktor Bojović <viktor.bojovic@gmail.com>)
List pgsql-sql
Tree view
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.bojovic@gmail.com> wrote:
\d tableName


On Wed, Jul 7, 2010 at 11:08 AM, venkat <ven.tammineni@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

pgsql-sql by date:

Previous
From: AI Rumman
Date:
Subject: Re: [GENERAL] How to Get Column Names from the Table
Next
From: Thomas Kellerer
Date:
Subject: Re: Cant execute the query