Thread: Desc table
<br /><br /><p><font face="Arial" size="2">Hi ALL</font><p><font face="Arial" size="2">I have a Quick/small Question.</font><br/><font face="Arial" size="2">Well today is the first day for me in the Postgresql.</font><br /><fontface="Arial" size="2">I want to "describe table" can any one tell me how to do it in postgresql.</font><p><font face="Arial"size="2">thanks</font><p><font face="Georgia" size="2">Suma Bommagani</font>
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