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: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Saturday, January 27, 2001 10:24 AM To: [EMAIL PROTECTED] 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
