Skip site navigation (1) Skip section navigation (2)

Re: show all tables?

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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

pgsql-novice by date

Next:From: Kassel Ben CRBEDate: 2002-10-28 14:46:42
Subject: Upgrading from 7.2.1 to 7.2.3 on RH7.3
Previous:From: Sigurdur HelgasonDate: 2002-10-28 13:12:19
Subject: Re: How to dynamically call a column in plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group