Re: How to Get Column Names from the Table

From: venkat <ven(dot)tammineni(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to Get Column Names from the Table
Date: 2010-07-07 09:17:27
Message-ID: AANLkTinFwK12Tz02gIvLaSGip2P39h_1DPZxl_YoMFeJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Thanks alot Andreas...It is working fine...

Thanks again.

Venkat

On Wed, Jul 7, 2010 at 2:44 PM, A. Kretschmer <
andreas(dot)kretschmer(at)schollglas(dot)com> wrote:

> In response to venkat :
> > Dear All,
> >
> > How to get Column Names from Table in PostgreSQL.
>
> select column_name from information_schema.columns where table_name =
> 'your_table';
>
>
> Regards, Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2010-07-07 09:29:46 Re: How to Get Column Names from the Table
Previous Message A. Kretschmer 2010-07-07 09:14:56 Re: How to Get Column Names from the Table

Browse pgsql-sql by date

  From Date Subject
Next Message Jayadevan M 2010-07-07 09:29:46 Re: How to Get Column Names from the Table
Previous Message A. Kretschmer 2010-07-07 09:14:56 Re: How to Get Column Names from the Table