X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 98E0E9DCC9D for ; Thu, 16 Feb 2006 05:34:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39544-01 for ; Thu, 16 Feb 2006 05:34:52 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by postgresql.org (Postfix) with ESMTP id DC9FB9DCCA7 for ; Thu, 16 Feb 2006 05:34:48 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i12so321747wra for ; Thu, 16 Feb 2006 01:34:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=es5N12vKAx87RPUZna3N6+PiP6LIz45mcGJFABT+mU+zLI22KXcCvGq10r7k+n+QaCXGMVLfEg8pt41wTfpDRN5WYHXpr/RJykDuEJYjAtQI9tBCxt2qt5eolNtsV/dz/EscTjakR2JueO2yCAcmG6s4W/CUejZtPR5r2sfKNvo= Received: by 10.65.214.19 with SMTP id r19mr104800qbq; Thu, 16 Feb 2006 01:34:50 -0800 (PST) Received: by 10.65.212.11 with HTTP; Thu, 16 Feb 2006 01:34:50 -0800 (PST) Message-ID: <4f31e3850602160134g4734e31s@mail.gmail.com> Date: Thu, 16 Feb 2006 11:34:50 +0200 From: Juris To: AKHILESH GUPTA Subject: Re: to count no of columns in a table Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/198 X-Sequence-Number: 24208 Create view/storedproc on pg_class & pg_attribute tables 2006/2/16, AKHILESH GUPTA : > 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 th= e > 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" >