Re: schema diagram

On Tue, Aug 15, 2000 at 03:19:42PM -0600, Ken Kinder wrote:
> Can anyone suggest how to get a big schema diagram for a Postgres
> database? We want one for the wall.

A particular database? Grab the patch to pgaccess that I posted about a
month ago, and start drawing. The patch does a couple things: it resizes
the canvas dynamically, so you can draw larger schema, and it allows
dragging multiple tables, so you can rearrange easier (try holding down
shift as you select tables: no rubber band select, sorry)

It's a little labor intensive, since you have to define all the linkages
yourself, by dragging and dropping fieldnames. The schema implementation
predates foreign key support in the backend, so it doesn't use that.

Then, the 'print' button will give you a big 'ol postscript file that
you'll have to massage to print however you can.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005