* 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