Skip site navigation (1) Skip section navigation (2)

to count no of columns in a table

From: AKHILESH GUPTA <akhilesh(dot)davim(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: to count no of columns in a table
Date: 2006-02-16 09:13:43
Message-ID: ad39daf90602160113u710dbdafq56359adfe8aee572@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
hi all,
i just want to know one thing that is there any function in PGSQL which
gives me the total number of columns in a table.
OR
just like we are using count(*), it gives us total number or rows in a
table, just like i want to know the total number of columns present in the
table
plz help me it's urgent
THANKS IN ADVANCE............!

--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)-INDIA

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

Responses

pgsql-sql by date

Next:From: JurisDate: 2006-02-16 09:34:50
Subject: Re: to count no of columns in a table
Previous:From: Michael GlaesemannDate: 2006-02-16 00:54:10
Subject: Re: alter table

pgsql-general by date

Next:From: JurisDate: 2006-02-16 09:34:50
Subject: Re: to count no of columns in a table
Previous:From: David FetterDate: 2006-02-16 08:28:08
Subject: Re: Oracle purchases Sleepycat - is this the "other shoe"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group