X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A862C8BA11F; Tue, 15 Feb 2005 10:48:03 +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 21333-05; Tue, 15 Feb 2005 10:48:00 +0000 (GMT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id DB61C8BA113; Tue, 15 Feb 2005 10:47:58 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 4.42) id 1D10FJ-0002CI-Bj; Tue, 15 Feb 2005 10:47:58 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 1688016595; Tue, 15 Feb 2005 10:47:55 +0000 (GMT) Message-ID: <4211D35C.1080004@archonet.com> Date: Tue, 15 Feb 2005 10:47:56 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Konstantin Danilov Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: How to view the list of tables? References: In-Reply-To: Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.065 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/813 X-Sequence-Number: 73617 Konstantin Danilov wrote: > 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? > Konstantin "man psql" will show you details of how to operate the psql application, or when in it try "\?" and "\h" to get help. We also now support the SQL-standard "information schema". You'll also find the manuals have this information - available with your installation and also online at http://www.postgresql.org/docs/ HTH -- Richard Huxton Archonet Ltd