Re: to count no of columns in a table - Mailing list pgsql-sql

Create view/storedproc on  pg_class & pg_attribute  tables

2006/2/16, AKHILESH GUPTA <akhilesh.davim@gmail.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"
>