\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"