Обсуждение: Schema Report??
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
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.
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. > >