Skip site navigation (1) Skip section navigation (2)

Re: system catalog views + tables

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: system catalog views + tables
Date: 2008-10-28 20:17:12
Message-ID: 20081028131712.4279a4c9@jd-laptop (view raw or whole thread)
Lists: pgsql-admin
On Tue, 28 Oct 2008 13:11:38 -0700
Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:

> 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

The documentation?

If you are in psql you can also do:

\d pg_ <tab> <tab>

Joshua D. Drake

The PostgreSQL Company since 1997: 
PostgreSQL Community Conference:
United States PostgreSQL Association:

In response to

pgsql-admin by date

Next:From: Marc FrommDate: 2008-10-29 15:40:21
Subject: drop role fails
Previous:From: Isabella GhiureaDate: 2008-10-28 20:11:38
Subject: system catalog views + tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group