Postgres Pro
Downloads
Home   >   mailing lists

DESCRIBE for composite type? - Mailing list pgsql-novice

From Nikita Koselev
Subject DESCRIBE for composite type?
Date
Msg-id 24e54d80810042354g27d6e589v5a8915134423af6a@mail.gmail.com
Whole thread Raw
Responses Re: DESCRIBE for composite type?  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: "Nikita Koselev"
Date:
Subject: array of composite types - how can I launch this function with an array of composite values
Next
From: "Nikita Koselev"
Date:
Subject: accessing composite value's field in function