From: | Chris Bowlby <chris(at)pgsql(dot)com> |
---|---|
To: | Chris Schneider <cschneider(at)xede(dot)com> |
Cc: | info(at)pgsql(dot)com, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Inquiry From Form [pgsql] |
Date: | 2002-11-21 13:28:19 |
Message-ID: | 20021121092340.H86773-100000@wired.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, 18 Nov 2002, Chris Schneider wrote:
Hi Chris,
PostgreSQL has something very similar to what Oracle does, although still
different:
pg_databases - Stores general information for each database.
pg_shadow - Stores information on the users, such as access levels,
passwords, etc.
pg_indexes - stores a list of all the active indecies, you can also use
this to get a listing of most of the other pg_tables...
and a bunch more, but these are the ones that are used the most..
> Where can I find a listing/explanation of all the system views for the PostgreSQL db. In other words, on Oracle I would query DBA_TABLES for all table definitions, or DBA_USERS for all db users. Would like to know the PostgreSQL equivalents. Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Chris Bowlby,
-----------------------------------------------------
chris(at)pgsql(dot)com
www.pgsql.com
1-902-542-0713
-----------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Genty Jean-Paul | 2002-11-21 13:41:59 | Re: Problems building Postgresql with multibyte enabled |
Previous Message | Henrique Spencer | 2002-11-21 13:01:48 | Error while compiling |