X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4762B8BA170; Fri, 11 Feb 2005 20:44:13 +0000 (GMT) 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 27754-08; Fri, 11 Feb 2005 20:44:04 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 36FAF8BA157; Fri, 11 Feb 2005 20:44:02 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j1BKhrPf022783 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 11 Feb 2005 13:43:56 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j1BKhrvE033160; Fri, 11 Feb 2005 13:43:53 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j1BKhrmF033159; Fri, 11 Feb 2005 13:43:53 -0700 (MST) (envelope-from mfuhr) Date: Fri, 11 Feb 2005 13:43:53 -0700 From: Michael Fuhr To: Zuoxin.Wang@kp.org Cc: pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org Subject: Re: describe Message-ID: <20050211204353.GA33129@winnie.fuhr.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/99 X-Sequence-Number: 16267 On Fri, Feb 11, 2005 at 12:23:56PM -0800, Zuoxin.Wang@kp.org wrote: > > Does anyone know psql command for 'describe'. It would be helpful if you explained what "describe" is supposed to do. Maybe you're looking for the \d family of commands in psql? See also the "System Catalogs" and "The Information Schema" chapters in the documentation (the latter in 7.4 and later). -- Michael Fuhr http://www.fuhr.org/~mfuhr/