* Konstantin Danilov <[EMAIL PROTECTED]> [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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
