Received: from hotmail.com (law-f38.hotmail.com [209.185.131.101]) by hub.org (8.10.1/8.10.1) with ESMTP id e99Fl8J59727 for ; Mon, 9 Oct 2000 11:47:08 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 9 Oct 2000 08:47:02 -0700 Received: from 61.11.231.197 by lw1fd.hotmail.msn.com with HTTP; Mon, 09 Oct 2000 15:47:02 GMT X-Originating-IP: [61.11.231.197] From: "omid omoomi" To: bcdoyle@mindspring.com, pgsql-sql@postgresql.org Subject: Re: Table Attribute Help Date: Mon, 09 Oct 2000 15:47:02 GMT Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 09 Oct 2000 15:47:02.0467 (UTC) FILETIME=[2ABF2130:01C03208] X-Archive-Number: 200010/85 Hi, >From: "Brian C. Doyle" >To: pgsql-sql@postgresql.org >Subject: [SQL] Table Attribute Help >Date: Mon, 09 Oct 2000 11:21:21 -0400 > >Hello all, > >I am trying to find a query to retrive the attributes of a table as in \d >tablename but as a select command. Is this possible? > > yes. try to run psql with -E and look at the related system tables when running \d command like (pg_class, pg_user, ...) regards Omid Omoomi _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.