Received: from chicago.murrain.net (h0050e4e65769.ne.mediaone.net [66.30.59.106]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26FVBx16081; Tue, 6 Mar 2001 10:31:11 -0500 (EST) (envelope-from mpm@norwottuck.com) Received: from chicago.murrain.net (localhost.localdomain [127.0.0.1]) by chicago.murrain.net (Postfix) with SMTP id 26D6353D47; Tue, 6 Mar 2001 10:29:24 -0500 (EST) From: Michelle Murrain Reply-To: mpm@norwottuck.com Organization: Norwottuck Technology Resources Date: Tue, 6 Mar 2001 10:29:23 -0500 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="us-ascii" To: Boulat Khakimov , Karel Zak , pgsql-sql@postgresql.org, pgsql-general@postgresql.org References: <3AA44897.121D60F0@inet-interactif.com> <20010306155522.B13152@ara.zf.jcu.cz> <3AA4FFF1.5875B665@inet-interactif.com> In-Reply-To: <3AA4FFF1.5875B665@inet-interactif.com> Subject: Re: Re: MySQLs Describe emulator! MIME-Version: 1.0 Message-Id: <01030610292300.01441@chicago.murrain.net> Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/251 X-Sequence-Number: 5732 On Tuesday 06 March 2001 10:19 am, Boulat Khakimov wrote: > Karel Zak wrote: > > > On Tue, Mar 06, 2001 at 09:14:54AM -0500, Boulat Khakimov wrote: > > > > > > 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" ? > > > > > > 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. > > > > As a programmer you can see psql source and directly found how SQL > > query execute this tool. The PostgreSQL needn't non-standard statements > > like MySQL's SHOW, DESC -- the postgreSQL has system catalogs. > > > > Karel > > Agreed! Why make someones life easier?? > Let's complicate things as much as possible that way it's more > fun,right? ;o) > > Dont understand how this works? No problem -- just read the source > code. > Dont understand how to get that to work? Not a problem -- read the > source code! > > The only problem tho, the source codes tend to be thousands of lines > when it comes > to DBs and time is ... And, further, some of us are web programmers, and the source code doesn't help one whit in getting DATA that one needs to do stuff on the front end, like data entry validation. Thanks much Boulat - you made the coding for my robust validator a lot easier to write and read... and it works well, too! Michelle ------------ Michelle Murrain, Ph.D. President Norwottuck Technology Resources mpm@norwottuck.com http://www.norwottuck.com