| From: | DE VOLDER Fabrice <fabrice(dot)devolder(at)cegetel(dot)fr> |
|---|---|
| To: | "'anuj'" <Anuj(at)in-control(dot)de> |
| Cc: | "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org> |
| Subject: | RE: Describe structure. |
| Date: | 2000-07-25 09:37:52 |
| Message-ID: | 649362D1822DD211BEB000A024A6D902435850@OCEANOS |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
\d tblpg
-----Message d'origine-----
De: anuj [mailto:Anuj(at)in-control(dot)de]
Date: mardi 25 juillet 2000 11:03
À: pgsql-general(at)hub(dot)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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | davidb | 2000-07-25 12:50:59 | Re: ROLLBACK automatically |
| Previous Message | anuj | 2000-07-25 09:03:13 | Describe structure. |