RE: Describe structure.

\d tblpg

-----Message d'origine-----
De: anuj [mailto:Anuj@in-control.de]
Date: mardi 25 juillet 2000 11:03
À: pgsql-general@hub.org
Objet: [GENERAL] Describe structure.


Hi,
My table name is tblpg.
I want to see the table structure.
Like oracle have Describe <table name>.
What PG have ? or any command.
Thank in advance.
Anuj

pg=> \d
Database    = pg
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | postgres         | tblpg                            | table    |
 +------------------+----------------------------------+----------+

pg=> describe tblpg;
ERROR:  parser: parse error at or near "describe"