From: | Michael Davis <mdavis(at)sevainc(dot)com> |
---|---|
To: | "'lbottorff(at)harveycounty(dot)com'" <lbottorff(at)harveycounty(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: Admin tutorials? |
Date: | 2001-01-27 18:27:58 |
Message-ID: | 01C08854.366F0610.mdavis@sevainc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-27 19:47:22 | Re: postgres limitation |
Previous Message | Bruce Momjian | 2001-01-27 18:12:23 | Re: Some thoughts on replication |