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 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
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 about PostgreSQL? > > Can I also see somehow the datatypes of tables' fields? > > \dt in psjl lists tables that should be 'psql', obviously. :) -- '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 6: Have you searched our list archives? http://archives.postgresql.org
