Re: show all tables?

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@student.mdh.se]
Sent: Friday, October 25, 2002 11:42 AM
To: pgsql-novice@postgresql.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