Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7929B65026E for ; Wed, 23 Jul 2008 12:58:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28567-04 for ; Wed, 23 Jul 2008 12:57:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id A83AE650489 for ; Wed, 23 Jul 2008 12:33:26 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1KLgL9-000597-6C for pgsql-admin@postgresql.org; Wed, 23 Jul 2008 15:33:19 +0000 Received: from 83.228.70.60 ([83.228.70.60]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 23 Jul 2008 15:33:19 +0000 Received: from milen by 83.228.70.60 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 23 Jul 2008 15:33:19 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Query a list of tables Date: Wed, 23 Jul 2008 18:33:02 +0300 Lines: 13 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 83.228.70.60 User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.599 tagged_above=0 required=5 tests=RCVD_IN_DNSWL_LOW=-1, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: * X-Archive-Number: 200807/197 X-Sequence-Number: 29807 Campbell, Lance написа: > Is there a list somewhere of the system catalog tables and examples of > querying it for administrative reasons? [...] http://www.postgresql.org/docs/current/static/information-schema.html http://www.postgresql.org/docs/current/static/catalogs.html This mostly means you need to acquaint yourself with the fine manual. -- Milen A. Radev