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

From Dick Davies
Subject Re: How to view the list of tables?
Date
Msg-id 20050215103751.GW63378@eris.tenfour
Whole thread Raw
In response to How to view the list of tables?  (Konstantin Danilov <danilov_konst@list.ru>)
Responses Re: How to view the list of tables?
List pgsql-sql
* Konstantin Danilov <danilov_konst@list.ru> [0222 10:22]:
> 
> 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?

\dt in psjl lists tables

( \d gives you things like sequences as well)

\d tablename shows its layout.


-- 
'Tempers are wearing thin. Let's hope some robot doesn't kill everybody.'    -- Bender
Rasputin :: Jack of All Trades - Master of Nuns


pgsql-sql by date:

Previous
From: Konstantin Danilov
Date:
Subject: How to view the list of tables?
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] How to view the list of tables?