Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Command - To List Tables ? - Mailing list pgsql-general

From mathan
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 0ff701c36c8b$636e41d0$250110ac@MAMCO
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
List pgsql-general
Tree view 
> Is there a SQL command I can issue which will list all the TABLES within
> a database ?

If you want to get database-specific attributes, such as tables, views,
etc... just try \? from the psql monitor, and you will get a list of nice
functions. '\dt' will list all tables, for example.

Thanks
--mathan

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: move to usenet?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: SQL Command - To List Tables ?