From: Dick Davies <rasputnik@hellooperator.net>
To: Konstantin Danilov <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:37:51 +0000
Message-ID: <20050215103751.GW63378@eris.tenfour> (raw)
In-Reply-To: <E1D0zlJ-000AQR-00.danilov_konst-list-ru@f24.mail.ru>
References: <E1D0zlJ-000AQR-00.danilov_konst-list-ru@f24.mail.ru>
* 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
( \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
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: <20050215103751.GW63378@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