Suma(dot)Bommagani(at)tdameritrade(dot)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