Received: from fido.inet-interactif.com (fido.inet-interactif.com [216.218.2.225]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26EDUx88537; Tue, 6 Mar 2001 09:13:30 -0500 (EST) (envelope-from boulat@inet-interactif.com) Received: from inet-interactif.com ([216.218.2.229]) by fido.inet-interactif.com (8.9.3/8.9.3) with ESMTP id JAA37242; Tue, 6 Mar 2001 09:13:07 -0500 (EST) (envelope-from boulat@inet-interactif.com) Message-ID: <3AA4F0DE.D96BA904@inet-interactif.com> Date: Tue, 06 Mar 2001 09:14:54 -0500 From: Boulat Khakimov Organization: Inet Interactif Inc. X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane , pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: MySQLs Describe emulator! References: <3AA44897.121D60F0@inet-interactif.com> <3764.983846777@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/244 X-Sequence-Number: 5722 Tom Lane wrote: > > 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" ? Hi, 1) "\d table" can only be used in psql, you cant run a query like that using libpq for example 2) as a programmer I need to be able to find out as much info as possible about any given field which is what "describe" for in mySQL. Regards, Boulat Khakimov -- Nothing Like the Sun