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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org