Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id DF99E2E0037
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 05:59:30 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 22451-07
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 05:59:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213])
	by developer.postgresql.org (Postfix) with ESMTP id 29F932E0084
	for <pgsql-sql@postgresql.org>; Thu, 17 Apr 2008 05:59:21 -0300 (ADT)
Received: from [84.51.143.99] (helo=server3.office.archonet.com)
	by ptb-relay02.plus.net with esmtp (Exim) id 1JmPxc-0006bB-Ob;
	Thu, 17 Apr 2008 09:59:16 +0100
Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id AAEB027403B;
	Thu, 17 Apr 2008 09:59:15 +0100 (BST)
Message-ID: <48071163.90706@archonet.com>
Date: Thu, 17 Apr 2008 09:59:15 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: VG <vikasraigupta@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Desc Commnad in pgsql?
References: <c4fdd6d00804170146l7aa56dbdy6a4ec006ad5eedc4@mail.gmail.com>
	<c4fdd6d00804170147t6519649ldbaa5660302df3be@mail.gmail.com>
In-Reply-To: <c4fdd6d00804170147t6519649ldbaa5660302df3be@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Plusnet-Relay: 303186b6151154df261396d5d281a947
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/110
X-Sequence-Number: 30649

VG wrote:
> Hello All,
> 
> I like to know how can I achieve the same functionality that is give by desc
> commnad in mysql or oracle.

http://www.postgresql.org/docs/8.3/static/app-psql.html

See the \d command, e.g. "\d mytable"

There are many different backslash commands that can give you details on 
tables, views, functions, schemas etc.

> Also specify me the book related to pgsql as a beginner.

http://www.postgresql.org/docs/8.3/static/index.html
http://www.postgresql.org/docs/books/

> Presently my task is going to be communication of ruby with pgsql

Start here I suppose:
http://rubyforge.org/projects/ruby-pg/

-- 
   Richard Huxton
   Archonet Ltd