X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 34D47DA361 for ; Sat, 5 Nov 2005 12:55:08 -0400 (AST) 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 96952-01 for ; Sat, 5 Nov 2005 16:55:05 +0000 (GMT) X-Greylist: delayed 00:07:18.440272 by SQLgrey- Received: from kiwi.adonten.net (kiwi.adonten.net [204.157.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id D190EDA04F for ; Sat, 5 Nov 2005 12:55:04 -0400 (AST) Received: (qmail 25414 invoked from network); 5 Nov 2005 16:47:56 -0000 Received: from localhost (127.0.0.1) by localhost with SMTP; 5 Nov 2005 16:47:56 -0000 Received: from 82-70-183-14.dsl.in-addr.zen.co.uk (82-70-183-14.dsl.in-addr.zen.co.uk [82.70.183.14]) by webmail.adontendev.net (IMP) with HTTP for ; Sat, 05 Nov 2005 16:47:56 +0000 Message-ID: <1131209276.436ce23cba2d2@webmail.adontendev.net> Date: Sat, 05 Nov 2005 16:47:56 +0000 From: frank church To: pgsql-sql@postgresql.org Subject: Extract table columns in tabular form MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 82.70.183.14 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.217 required=5 tests=[AWL=0.217] X-Spam-Score: 0.217 X-Spam-Level: X-Archive-Number: 200511/60 X-Sequence-Number: 23311 How do you extract postgresql column names, types and comments in tabular form, using an SQL command?. I know they are stored in one of the system tables, but I don't know which. R Church ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.