Groups > comp.databases.postgresql > #294

Teasing a type definition from system tables

From	Don Y <this@isnotme.com>
Newsgroups	comp.databases.postgresql
Subject	Teasing a type definition from system tables
Date	2012-01-31 08:43 -0700
Organization	Aioe.org NNTP Server
Message-ID	<jg9265$9t4$1@speranza.aioe.org> (permalink)

Show all headers | View raw

Hi,

For "non-standard" types (e.g., composite, user-defined), is there
any way of teasing the definition out of the system catalog?

E.g.,

CREATE TYPE foo AS (
   control1 point,
   control2 point,
   dest point
);

CREATE TYPE bar AS (
   purpose text,
   action foo,
   when date
);

It seems like type definitions fall into a black hole...

Thx,
--don

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-01-31 08:43 -0700
  Re: Teasing a type definition from system tables Username <someone@invalid.tld> - 2012-02-02 00:41 +0100
    Re: Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-02-05 03:18 -0700
  Re: Teasing a type definition from system tables Jasen Betts <jasen@xnet.co.nz> - 2012-02-03 10:47 +0000
    Re: Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-02-08 01:18 -0700

csiph-web