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