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

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ć wrote: > \d tableName > > > On Wed, Jul 7, 2010 at 11:08 AM, venkat wrote: > >> Dear All, >> >>How to

Re: [GENERAL] [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 wrote: > Hi, > > To get column names only > > select column_name from information_schema.columns where > table_name='captor_prime_aggregates'; > > Thanks > Sreelatha > On

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

Thanks alot Andreas...It is working fine... Thanks again. Venkat On Wed, Jul 7, 2010 at 2:44 PM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > In response to venkat : > > Dear All, > > > >How to get Column Names from Table in PostgreSQL. > > select column_name from informatio

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

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:

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

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

[SQL] How to Get Column Names from the Table

Dear All, How to get Column Names from Table in PostgreSQL. Thanks and Regards, Venkat