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 or flat)
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


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-2014 The PostgreSQL Global Development Group