From: Dick Davies <rasputnik@hellooperator.net>
To: danilov_konst@list.ru
Cc: PostgreSQL SQL list <pgsql-sql@postgresql.org>
Subject: Re: How to view the list of tables?
Date: Tue, 15 Feb 2005 10:49:30 +0000
Message-ID: <20050215104930.GX63378@eris.tenfour> (raw)
In-Reply-To: <20050215103751.GW63378@eris.tenfour>
References: <E1D0zlJ-000AQR-00.danilov_konst-list-ru@f24.mail.ru>
<20050215103751.GW63378@eris.tenfour>
* Dick Davies <rasputnik@hellooperator.net> [0241 10:41]:
> * Konstantin Danilov <danilov_konst@list.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rasputnik@hellooperator.net, danilov_konst@list.ru
Subject: Re: How to view the list of tables?
In-Reply-To: <20050215104930.GX63378@eris.tenfour>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox