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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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