Re: Desc table - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Desc table
Date
Msg-id 45884349.6000105@archonet.com
Whole thread Raw
In response to Desc table  (<Suma.Bommagani@tdameritrade.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From:
Date:
Subject: Desc table
Next
From: Richard Ray
Date:
Subject: Help with quotes in plpgsql