Re: How to view the list of tables?

* 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