pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jean-Max Reymond <Jean-Max.Reymond@bull.net>
To: pgsql-sql@postgresql.org
Subject: SQL request to  retrieve the type of columns
Date: Tue, 12 Feb 2002 16:45:55 +0100
Message-ID: <3C6938B3.3060208@bull.net> (raw)

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.net
 Address:  BULL SLDV (Saint Laurent du Var)
============================================================================





view thread (3+ messages)  latest in thread

Message-ID: <3C6938B3.3060208@bull.net>
Permalink:  ../3C6938B3.3060208@bull.net/
Also on:    postgresql.org/message-id/3C6938B3.3060208@bull.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Jean-Max.Reymond@bull.net
  Subject: Re: SQL request to  retrieve the type of columns
  In-Reply-To: <3C6938B3.3060208@bull.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox