pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: damien clochard <damien@dalibo.info>
To: pgsql-admin@postgresql.org
Cc: isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: system catalog views + tables
Date: Thu, 30 Oct 2008 09:52:18 +0100
Message-ID: <490975C2.2090702@dalibo.info> (raw)
In-Reply-To: <490771FA.4000900@nrc-cnrc.gc.ca>
References: <490771FA.4000900@nrc-cnrc.gc.ca>

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





view thread (4+ messages)  latest in thread

Message-ID: <490975C2.2090702@dalibo.info>
Permalink:  ../490975C2.2090702@dalibo.info/
Also on:    postgresql.org/message-id/490975C2.2090702@dalibo.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: damien@dalibo.info, isabella.ghiurea@nrc-cnrc.gc.ca
  Subject: Re: system catalog views + tables
  In-Reply-To: <490975C2.2090702@dalibo.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox