Received: from mail.com-stock.com (mail.com-stock.com [204.255.137.254]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f264m4x04043 for ; Mon, 5 Mar 2001 23:48:04 -0500 (EST) (envelope-from gregw@com-stock.com) Received: by mail.com-stock.com (Postfix, from userid 1000) id 7B842DF; Mon, 5 Mar 2001 23:48:01 -0500 (EST) Received: from deimos (deimos.com-stock.com [204.255.137.120]) by mail.com-stock.com (Postfix) with SMTP id 203ECD9DD for ; Mon, 5 Mar 2001 23:48:00 -0500 (EST) Message-ID: <002f01c0a5f9$1513e900$7889ffcc@comstock.com> From: "Gregory Wood" To: "PostgreSQL-General" References: <3AA44897.121D60F0@inet-interactif.com> <3764.983846777@sss.pgh.pa.us> Subject: Re: MySQLs Describe emulator! Date: Mon, 5 Mar 2001 23:48:07 -0500 Organization: Comstock Net Services MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200103/233 X-Sequence-Number: 5711 > Boulat Khakimov writes: > > Here is a nifty query I came up with > > that provides a detailed information on any row of any table. > > Something that is build into mySQL (DESC tablename fieldname) > > but not into PG. > > Er, what's wrong with psql's "\d table" ? Those without shell access (or those of us who have access but use tools other than psql) would like in on the fun too :) Greg