Postgres Pro
Downloads
Home   >   mailing lists

Re: How to view the list of tables? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: How to view the list of tables?
Date
Msg-id 200502151634.39458.ghodechhap@ghodechhap.net
Whole thread Raw
In response to How to view the list of tables?  (Konstantin Danilov <danilov_konst@list.ru>)
List pgsql-general
Tree view 
On Tuesday 15 Feb 2005 3:46 pm, Konstantin Danilov wrote:
> 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?

In psql, you can try '\dt' and '\d table name'. Type \? for more commands..

 Shridhar

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: Lost rows/data corruption?
Next
From: Geoffrey
Date:
Subject: Re: /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG