From: | Colin Wetherbee <cww(at)denterprises(dot)org> |
---|---|
To: | Colin Fox <cfox(at)cfconsulting(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Autograph Annoucement (ERD Tool) |
Date: | 2008-04-04 02:36:44 |
Message-ID: | 47F5943C.3060006@denterprises.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Colin Wetherbee wrote:
> Also, is there a way to forcibly remove tables and views from the
> output? In all.xml, I only list the tables I want, but in addition to
> those, I also get my PostGIS tables and all the views I've created
> within the schema.
And...
If I set the tablemode to "detailed", all the lines terminate at primary
keys, instead of terminating at a primary key and a foreign key, which,
I assume, is what should happen.
An example...
TABLE mytable
id PRIMARY KEY
foo_id REFERENCES foo(id)
TABLE foo
id PRIMARY KEY
The output of your tool would show a link between mytable.id and foo.id,
instead of a link between mytable.foo_id and foo.id.
I don't think I'll use the detailed view very often, though; I just
wanted to see what it did. :)
Here's the sample "detailed" output from one of my databases:
http://colinwetherbee.com/data/js-20080403.png
Thanks again for this neat, lean tool.
Colin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-04 02:42:33 | Re: pg_dump ignoring without oids |
Previous Message | Chris Velevitch | 2008-04-04 02:21:26 | pg_dump ignoring without oids |