SQL request to retrieve the type of columns

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.Reymond@bull.netAddress:
BULLSLDV (Saint Laurent du Var)
 
============================================================================