Postgres Pro
Downloads
Home   >   mailing lists

Thread: Inquiry From Form [pgsql]

Inquiry From Form [pgsql]

From
Chris Schneider
Date:
Where can I find a listing/explanation of all the system views for the PostgreSQL db.  In other words, on Oracle I
wouldquery 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]

From
Jeff Boes
Date:
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]

From
Chris Bowlby
Date:
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
wouldquery 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
 -----------------------------------------------------