| From: | Jean-Max Reymond <Jean-Max(dot)Reymond(at)bull(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | SQL request to retrieve the type of columns |
| Date: | 2002-02-12 15:45:55 |
| Message-ID: | 3C6938B3.3060208@bull.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I am looking for a SQL request (must be executed in a ECPG program) to
retrieve the type of each column in a Postgres table.
For example,
\d wapi
Table "wapi"
Attribute | Type | Modifier
------------+-----------------------+----------
wapinom | character(8) |
wapicall | character varying(12) |
wapitrans | character varying(4) |
wapistruct | character varying(50) |
It will be great to have the same result with a "select request".
regards,
--
Jean-Max Reymond
============================================================================
Email : Jean-Max(dot)Reymond(at)bull(dot)net
Address: BULL SLDV (Saint Laurent du Var)
============================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2002-02-12 15:52:47 | Re: SQL request to retrieve the type of columns |
| Previous Message | Bhuvan A | 2002-02-12 13:40:10 | Re: Sequencing Problem in Transaction.. |