Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 0E0A39F9386
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 15:53:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 28199-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 15:53:44 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by postgresql.org (Postfix) with ESMTP id EE5699F9FE1
	for <pgsql-sql@postgresql.org>; Tue, 19 Dec 2006 15:53:46 -0400 (AST)
Received: from mainbox.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 0911774642;
	Tue, 19 Dec 2006 19:53:46 +0000 (GMT)
Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP id 568ECFF04;
	Tue, 19 Dec 2006 19:53:45 +0000 (GMT)
Message-ID: <45884349.6000105@archonet.com>
Date: Tue, 19 Dec 2006 19:53:45 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 1.5.0.8 (X11/20061115)
MIME-Version: 1.0
To: Suma.Bommagani@tdameritrade.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Desc table
References: 
 <3C4C257C1896D446BEEA5C5C23525FC8023BB558@prdcgwsemlmb01.prod-am.ameritrade.com>
In-Reply-To: 
 <3C4C257C1896D446BEEA5C5C23525FC8023BB558@prdcgwsemlmb01.prod-am.ameritrade.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/140
X-Sequence-Number: 27096

Suma.Bommagani@tdameritrade.com wrote:
> 
> Hi ALL
> 
> I have a Quick/small  Question.
> Well today is the first day for me in the Postgresql.
> I want to "describe table" can any one tell me how to do it in
> postgresql.

If in psql, try
   \d <table-name>
See the psql section of the manual for details.

Most GUI tools (e.g. pgadmin) off a column-view of a table.

The system-catalogues and information_schema views are a way to describe 
tables programmatically.

HTH
-- 
   Richard Huxton
   Archonet Ltd