Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E822264FC57 for ; Thu, 30 Oct 2008 05:52:26 -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 46368-01 for ; Thu, 30 Oct 2008 05:52:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id DB0E464FC60 for ; Thu, 30 Oct 2008 05:52:22 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id 37B1F578070; Thu, 30 Oct 2008 09:52:20 +0100 (CET) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id oxKGO+-pM9qV; Thu, 30 Oct 2008 09:52:20 +0100 (CET) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id 10914578074; Thu, 30 Oct 2008 09:52:20 +0100 (CET) Received: from [192.168.0.104] (lns-bzn-43-82-249-174-35.adsl.proxad.net [82.249.174.35]) by pyrrha.dalibo.net (Postfix) with ESMTP id 33101578070; Thu, 30 Oct 2008 09:52:19 +0100 (CET) Message-ID: <490975C2.2090702@dalibo.info> Date: Thu, 30 Oct 2008 09:52:18 +0100 From: damien clochard User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: isabella.ghiurea@nrc-cnrc.gc.ca Subject: Re: system catalog views + tables References: <490771FA.4000900@nrc-cnrc.gc.ca> In-Reply-To: <490771FA.4000900@nrc-cnrc.gc.ca> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/180 X-Sequence-Number: 30636 Isabella Ghiurea a écrit : > Hello, > How can I see all system catalog tables and views , I'm in potsgres db > ( using PG 8.3). > Is there a way to have /get a full list and description of system > tables and views in kind of hard copy format, same as Oracle or > RDBMS posters for system catalogs objects? > thank you, > Isabella Hi ! Here's a poster of PostgreSQL 8.3 internal catalogs http://dalibo.org/_media/articles/catalog.png?cache=cache SVG version is available here : http://svn.postgresql.fr/repos/materials/advocacy/trunk/posters/catalogs83.svg Hope this helps... -- damien clochard http://dalibo.org | http://dalibo.com