Inquiry From Form [pgsql]
Inquiry From Form [pgsql]
От:
Chris Schneider <cschneider@xede.com>
Дата:
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
Re: Inquiry From Form [pgsql]
От:
Jeff Boes <jboes@nexcerpt.com>
Дата:
On Tue, 19 Nov 2002 08:27:25 -0500, Chris Schneider wrote:
> 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
In the HTML documentation possibly installed on your system when
PostgreSQL was installed. Failing there, it's found here:
http://www.postgresql.org/idocs/index.php?catalogs.html
--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise
Re: Inquiry From Form [pgsql]
От:
Chris Bowlby <chris@pgsql.com>
Дата:
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@pgsql.com
www.pgsql.com
1-902-542-0713
-----------------------------------------------------