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

Hi Don,

Have a look at MogwaiERDesignerNG and its reverseengineering
capabilities: http://sourceforge.net/projects/mogwai/

The way it is done you can find in

http://mogwai.svn.sourceforge.net/vi...22&view=markup

in the lines

194 for enumerations,
233 for composite types
312 for external types (not implemented yet)

HTH

regards

On 2012-01-31, Don Y <this (AT) isnotme (DOT) com> wrote:
see how psql does it:

psql -E
\d bar


--
⚂⚃ 100% natural

--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---

On 2/1/2012 4:41 PM, Username wrote:
Excellent! I may actually look into using the tool, itself.

Thanks!

Hi Jasen,

On 2/3/2012 3:47 AM, Jasen Betts wrote:
Thanks! I'll try that next time I am logged onto the server.