Skip site navigation (1) Skip section navigation (2)

DESCRIBE for composite type?

From: "Nikita Koselev" <koselev(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: DESCRIBE for composite type?
Date: 2008-10-05 06:54:10
Message-ID: 24e54d80810042354g27d6e589v5a8915134423af6a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I've created an composite type.
--
CREATE TYPE requirement_vo AS (
 name VARCHAR(20),
 description VARCHAR(20),
 requirement_id INT,
 requirement_type_id INT,
 priority_id INT,
 necessity_id INT,
 lower_limit DOUBLE PRECISION,
 upper_limit DOUBLE PRECISION
 );
--
How can I get description of this composite type later (field names
and values)? Is there something in pgsql like DESCRIBE statement in
oracle?

Responses

pgsql-novice by date

Next:From: Nikita KoselevDate: 2008-10-05 06:59:20
Subject: accessing composite value's field in function
Previous:From: Nikita KoselevDate: 2008-10-05 06:51:39
Subject: array of composite types - how can I launch this function with an array of composite values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group