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, ----------------------------------------------------- [EMAIL PROTECTED] www.pgsql.com 1-902-542-0713 ----------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])