Search Postgresql Archives

Re: Documenting PGSQL database.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




7 apr 2007 kl. 21.07 skrev RPK:


I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way
of documenting the schema of PGSQL database so that I can get a printed copy
of the same.


Some years ago (2003) I did that, and published it at <http://www.linuxbog.dk/dokumentation/dokumentation/c1187.html>

Now, that is written in swedish, but by looking at the examples and scripts you will
get the idea.

it's a pgtcl script that makes use of data from pg_catalog.

It produces a xml-file, that is supposed to be put through an xsl transformation
tool that will end up the data in docbook format. Also some information of setting up
a  docbook toolchain is provided,

Now, at the time, PG 7.3.1 was I got, so it might not be still correct.

In the end, there is a makefile example of genrating html and pdf of it.
Given you are on windows, the makfile commands may be run by hand instead.

I think pgtcl will run on windows, and the docbook tools I used were all java.


/Björn

Björn Lundin
b dot f dot lundin at gmail dot com




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux