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)
============================================================================
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