pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Desc table
2+ messages / 2 participants
[nested] [flat]

* Desc table
@ 2006-12-19 19:34  Suma.Bommagani@tdameritrade.com
  0 siblings, 1 reply; 2+ messages in thread

From: Suma.Bommagani@tdameritrade.com @ 2006-12-19 19:34 UTC (permalink / raw)
  To: pgsql-sql



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.

thanks

Suma  Bommagani

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Desc table
@ 2006-12-19 19:53  Richard Huxton <dev@archonet.com>
  parent: Suma.Bommagani@tdameritrade.com
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2006-12-19 19:53 UTC (permalink / raw)
  To: Suma.Bommagani@tdameritrade.com; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-12-19 19:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-19 19:34 Desc table Suma.Bommagani@tdameritrade.com
2006-12-19 19:53 ` Richard Huxton <dev@archonet.com>

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