Re: Desc Commnad in pgsql?

From: Richard Huxton <dev(at)archonet(dot)com>
To: VG <vikasraigupta(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Desc Commnad in pgsql?
Date: 2008-04-17 08:59:15
Message-ID: 48071163.90706@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message dipesh 2008-04-17 10:38:17 Error in restore the Database in Postgres
Previous Message A. Kretschmer 2008-04-17 08:53:37 Re: Desc Commnad in pgsql?