Re: to count no of columns in a table

Create view/storedproc on pg_class & pg_attribute tables

2006/2/16, AKHILESH GUPTA <akhilesh(dot)davim(at)gmail(dot)com>:
> 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"
>