X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1BA8411F6AA9 for ; Sun, 2 Apr 2006 10:17:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68882-09 for ; Sun, 2 Apr 2006 10:17:22 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 0C58311F6D8D for ; Sun, 2 Apr 2006 10:17:21 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k32DHEuf078107 for ; Sun, 2 Apr 2006 10:17:15 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k32D32C0075764 for pgsql-admin@postgresql.org; Sun, 2 Apr 2006 10:03:02 -0300 (ADT) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Show tables query Date: Sun, 02 Apr 2006 08:48:37 -0400 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <878xqo9m8q.fsf@wolfe.cbbrowne.com> References: <20060402090706.6EB0911F6B01@postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:Ey6PD1J+XGnUs4HrBZ8mNPHuj/Y= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.246 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.194] X-Spam-Score: -1.246 X-Spam-Level: X-Archive-Number: 200604/11 X-Sequence-Number: 21180 After takin a swig o' Arrakan spice grog, andy.shellam@mailnetwork.co.uk ("Andy Shellam") belched out: > Is there an SQL command supported by Postgres to return a list of tables in a database? Yes, it's called SELECT. There is a standard schema called INFORMATION_SCHEMA, which contains a variety of relevant views. Notably, you could request: SELECT * FROM INFORMATION_SCHEMA.TABLES; That has the merit of actually conforming to SQL standards... -- output = reverse("moc.liamg" "@" "enworbbc") http://cbbrowne.com/info/ They have finally found the most ultimately useless thing on the web... Found at the Victoria's Secret website: "The online shop: Text Only Listing"