Re: Schema Report??

It's rumoured that Dan Sherwin once said:
> In the prior version og pgAdmin there was a report included that dumped
> a report laying out the complete schema for a database. Does anyone
> know if there is a way to something similar with pgAdmin II? I just
> want a easily readable view of my entire database configuration.
>
> }Dan

Hi Dan,

The reports system was not included in pgAdmin II for a number of reasons:

1) Not many people used it (at least if they did, they wouldn't admit to
it!).
2) It added a lot of extra files (and a few Mb) to the distribution.
3) It made the code *significantly* more complex both to enhance &
maintain.

Anyway, currently the only option you have is to save the schema itself to
file and use that as your report. You can do this by selecting a database
in the treeview and using 'Save DB Schema' on the File menu, or if you
prefer, just select a single object and use 'Save Definition' from the
File menu.

The output to both of these options should be fairly nicely formatted...

Regards, Dave.