Re: [SQL] How to view the list of tables?

* Dick Davies <[EMAIL PROTECTED]> [0241 10:41]: > * 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

Re: [SQL] How to view the list of tables?

* 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