Re: How to view the list of tables?

From: Dick Davies <rasputnik(at)hellooperator(dot)net>
To: danilov_konst(at)list(dot)ru
Cc: PostgreSQL SQL list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to view the list of tables?
Date: 2005-02-15 10:49:30
Message-ID: 20050215104930.GX63378@eris.tenfour
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

* Dick Davies <rasputnik(at)hellooperator(dot)net> [0241 10:41]:
> * Konstantin Danilov <danilov_konst(at)list(dot)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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2005-02-15 10:56:51 Re: Lost rows/data corruption?
Previous Message Richard Huxton 2005-02-15 10:47:56 Re: How to view the list of tables?

Browse pgsql-sql by date

  From Date Subject
Next Message Shridhar Daithankar 2005-02-15 11:04:39 Re: How to view the list of tables?
Previous Message Richard Huxton 2005-02-15 10:47:56 Re: How to view the list of tables?