From: Richard Huxton <dev@archonet.com>
To: Suma.Bommagani@tdameritrade.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Desc table
Date: Tue, 19 Dec 2006 19:53:45 +0000
Message-ID: <45884349.6000105@archonet.com> (raw)
In-Reply-To: <3C4C257C1896D446BEEA5C5C23525FC8023BB558@prdcgwsemlmb01.prod-am.ameritrade.com>
References: <3C4C257C1896D446BEEA5C5C23525FC8023BB558@prdcgwsemlmb01.prod-am.ameritrade.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, Suma.Bommagani@tdameritrade.com
Subject: Re: Desc table
In-Reply-To: <45884349.6000105@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox