Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1597064FD2A for ; Tue, 28 Oct 2008 17:11:58 -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 76515-07 for ; Tue, 28 Oct 2008 17:11:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenexf1.nrc.ca (nrccenexf1.nrc.ca [132.246.15.80]) by postgresql.org (Postfix) with ESMTP id 70CAB64FCE8 for ; Tue, 28 Oct 2008 17:11:54 -0300 (ADT) Received: from nrccenexf2.nrc.ca ([132.246.15.83]) by nrccenexf1.nrc.ca with Microsoft SMTPSVC(6.0.3790.3959); Tue, 28 Oct 2008 16:11:51 -0400 Received: from [192.168.11.203] ([132.246.15.67]) by nrccenexf2.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Tue, 28 Oct 2008 16:11:51 -0400 Message-ID: <490771FA.4000900@nrc-cnrc.gc.ca> Date: Tue, 28 Oct 2008 13:11:38 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 1.5.0.12 (X11/20070530) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: system catalog views + tables Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Oct 2008 20:11:51.0534 (UTC) FILETIME=[6A4118E0:01C93939] 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/166 X-Sequence-Number: 30622 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