X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D04A58BA150 for ; Tue, 15 Feb 2005 10:49:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22737-01 for ; Tue, 15 Feb 2005 10:49:32 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 96DB88BA11F for ; Tue, 15 Feb 2005 10:49:32 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1D10Gp-000021-1S; Tue, 15 Feb 2005 10:49:32 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1D10Go-000ESo-OE; Tue, 15 Feb 2005 10:49:30 +0000 Date: Tue, 15 Feb 2005 10:49:30 +0000 From: Dick Davies To: danilov_konst@list.ru Cc: PostgreSQL SQL list Subject: Re: How to view the list of tables? Message-ID: <20050215104930.GX63378@eris.tenfour> Reply-To: Dick Davies References: <20050215103751.GW63378@eris.tenfour> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050215103751.GW63378@eris.tenfour> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.532 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/150 X-Sequence-Number: 20261 * Dick Davies [0241 10:41]: > * Konstantin Danilov [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