RE: Admin tutorials?

[Michael Davis <mdavis(at)sevainc(dot)com>]

In psql, type \dS.  This will report all the system tables.

For example: 

Select * from pg_tables; 

Will select info on all your tables.

Here is a link that describes most of the system tables:

http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm



-----Original Message-----
From:	lbottorff(at)harveycounty(dot)com [SMTP:lbottorff(at)harveycounty(dot)com]
Sent:	Saturday, January 27, 2001 10:24 AM
To:	pgsql-admin(at)postgresql(dot)org
Subject:	Admin tutorials?

I've looked at psql and found good stuff, but I still don't know how to get a
listing of all my tables. I know in Oracle it's a SELECT statement, and I take
it for granted a lot of admin is done with regular SQL commands, where can I
learn such stuff as how to list my tables?

LB