Quick Links

How to view the list of tables ?

From:	Konstantin Danilov <danilov_konst(at)list(dot)ru>
To:	pgsql-sql(at)postgresql(dot)org
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	How to view the list of tables ?
Date:	2005-02-15 10:16:57
Message-ID:	E1D0zlJ-000AQR-00.danilov_konst-list-ru@f24.mail.ru
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-sql

Hello, list!
I need to view the list of tables in a database. In MySQL I can do it with the command "SHOW TABLES". What about PostgreSQL?
Can I also see somehow the datatypes of tables' fields?
Konstantin

Responses

Re: How to view the list of tables? at 2005-02-15 10:37:51 from Dick Davies
Re: How to view the list of tables? at 2005-02-15 10:47:56 from Richard Huxton
Re: How to view the list of tables? at 2005-02-15 11:04:39 from Shridhar Daithankar
Re: How to view the list of tables? at 2005-02-15 11:15:51 from Mihail Nasedkin

Browse pgsql-general by date

	From	Date	Subject
Next Message	Dick Davies	2005-02-15 10:37:51	Re: How to view the list of tables?
Previous Message	John Sidney-Woollett	2005-02-15 09:58:29	Slony uninstall info/warning

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Dick Davies	2005-02-15 10:37:51	Re: How to view the list of tables?
Previous Message	Theo Galanakis	2005-02-15 03:46:59	Re: Working with XML.