X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B1F674763CE for ; Tue, 6 May 2003 08:59:40 -0400 (EDT) Received: from rtlocal.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id D8D2F475E77 for ; Tue, 6 May 2003 08:59:33 -0400 (EDT) Received: (qmail 8942 invoked from network); 6 May 2003 13:01:00 -0000 Received: from unknown (HELO system67.trade-india-local.com) (unknown) by unknown with SMTP; 6 May 2003 13:01:00 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Popeanga Marian , pgsql-sql@postgresql.org Subject: Re: pg_ ? Date: Tue, 6 May 2003 18:29:36 +0530 User-Agent: KMail/1.5 References: <3EB7A462.5010901@cnlo.ro> In-Reply-To: <3EB7A462.5010901@cnlo.ro> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305061829.36866.mallah@trade-india.com> X-Spam-Status: No, hits=-33.1 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/82 X-Sequence-Number: 13247 pg_attribute. in general if you start psql with -E option psql will print the various queries which it uses on system catalogs for displaying various kind of information. Regds mallah. On Tuesday 06 May 2003 5:32 pm, Popeanga Marian wrote: > Hello all, > > > Witch is the system view from where i can get columns for all > tables and views ? > Just like when pgsql> \d view -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.