X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1DFFAD793D for ; Wed, 24 Aug 2005 15:19:33 -0300 (ADT) 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 34005-03 for ; Wed, 24 Aug 2005 18:19:31 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 78885D7952 for ; Wed, 24 Aug 2005 15:19:27 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id E1D661525A; Wed, 24 Aug 2005 13:19:23 -0500 (CDT) Date: Wed, 24 Aug 2005 13:19:23 -0500 From: "Jim C. Nasby" To: Gnanavel S Cc: sandhya , postgre , Sivakumar K Subject: Re: Reg:sql command Message-ID: <20050824181923.GS96732@pervasive.com> References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 required=5 tests=[AWL=0.010] X-Spam-Level: X-Archive-Number: 200508/305 X-Sequence-Number: 18624 You should also take a look at http://pgfoundry.org/projects/newsysviews/; it makes getting this kind of info out of the database much easier. On Wed, Aug 24, 2005 at 02:43:31PM +0530, Gnanavel S wrote: > run the psql command with -E option and do > \d tablename. > > On 8/24/05, sandhya wrote: > > > > Hi, > > Is there any equivalent command for '\d tablename'. > > Inorder to get the table structure is there any SQL query in postgres? > > Thank you, > > Regards, > > sandhya > > > > > > -- > with regards, > S.Gnanavel > Satyam Computer Services Ltd. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461