I am pretty new to postgresql -- but try using psql then \dtIs (for tables
you can also select * from pg_tables, pg_indexes, pg_trigger
Hope this helps!
From: Rikard Neidenmark [mailto:rnk01001(at)student(dot)mdh(dot)se]
Sent: Friday, October 25, 2002 11:42 AM
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
pgsql-novice by date
|Next:||From: Kassel Ben CRBE||Date: 2002-10-28 14:46:42|
|Subject: Upgrading from 7.2.1 to 7.2.3 on RH7.3|
|Previous:||From: Sigurdur Helgason||Date: 2002-10-28 13:12:19|
|Subject: Re: How to dynamically call a column in plpgsql|