Обсуждение: Schema Report??

Поиск
Список
Период
Сортировка

Schema Report??

От
Dan Sherwin
Дата:
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

Re: Schema Report??

От
"Dave Page"
Дата:
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.




Re: Schema Report??

От
Dan Sherwin
Дата:
Me??  Admit to it??  I can neither confirm nor deny having said anything to
that nature.  <g> Thanks Dave.

}Dan

On Mon, Dec 03, 2001 at 08:23:00PM -0000, Dave Page wrote:
> 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.
>
>