| From: | Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com> |
|---|---|
| To: | Rikard Neidenmark <rnk01001(at)student(dot)mdh(dot)se>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: show all tables? |
| Date: | 2002-10-28 13:34:17 |
| Message-ID: | 2E4528861499D41199D200A0C9B15BC001D50BC5@FRISTX |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi
I am pretty new to postgresql -- but try using psql then \dtIs (for tables
indexes sequences)
you can also select * from pg_tables, pg_indexes, pg_trigger
Hope this helps!
Pam Wampler
-----Original Message-----
From: Rikard Neidenmark [mailto:rnk01001(at)student(dot)mdh(dot)se]
Sent: Friday, October 25, 2002 11:42 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] show all tables?
Is there any way to show all tables and/or triggers in a database? I'm not
sure but I think the command in oracle is a "SELECT * FROM USER_TABLES;" or
something similar.
Richard Neidenmark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kassel Ben CRBE | 2002-10-28 14:46:42 | Upgrading from 7.2.1 to 7.2.3 on RH7.3 |
| Previous Message | Sigurdur Helgason | 2002-10-28 13:12:19 | Re: How to dynamically call a column in plpgsql |