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 CEF3D8BA123 for ; Tue, 15 Feb 2005 10:38:01 +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 19619-08 for ; Tue, 15 Feb 2005 10:37:58 +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 E49928BA113 for ; Tue, 15 Feb 2005 10:37:54 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1D105Y-0003Dn-85; Tue, 15 Feb 2005 10:37:53 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1D105Y-000Dk8-37; Tue, 15 Feb 2005 10:37:52 +0000 Date: Tue, 15 Feb 2005 10:37:51 +0000 From: Dick Davies To: Konstantin Danilov Cc: PostgreSQL SQL list Subject: Re: How to view the list of tables? Message-ID: <20050215103751.GW63378@eris.tenfour> Reply-To: Dick Davies References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.539 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/148 X-Sequence-Number: 20259 * 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 ( \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