Documenting PGSQL database.

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

On Sat, 7 Apr 2007 12:07:44 -0700 (PDT), rpk.general@gmail.com (RPK)
wrote:
in <9886934.post@talk.nabble.com>

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.

Bj�rn's tool looks like your best bet, but I'd like to add that the best
way to do this to never create your database(s) other than via script
and then you automatically have what you need by default. :-)

---
Stefan Berglund

On Apr 7, 4:07 pm, rpk.gene...@gmail.com (RPK) wrote:

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.
--
View this message in context:http://www.nabble.com/Documenting-PGSQL-database.-tf3541712.html#a988...
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Don't know if this helps, but have you tried;

SELECT * FROM INFORMATION_SCHEMA.tables
- or -
SELECT * FROM INFORMATION_SCHEMA.columns

Have added benefit of being and SQL standard so works on MS-SQL too.

Geoff.

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.

Hmm, I did not get my own post , so I thought I'd reply on this one
again
Looking through what has happened since 2003, when I wrote that
documentation thing, I decided to update a bit, translate it to english,
provide a small sample of how it can look, and changing the toolchain.

It is at

<http://lundin.homelinux.net/docbook_xml/target/html/
dbdocumentation.html>

/Björn

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

Hello All,

here are many tools available to create the attractive documentation of PostgreSQL Database in different formats.

With Reagrds
Ashish...

Bj�rn Lundin <b.f.lundin@gmail.com> wrote:

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.

Hmm, I did not get my own post , so I thought I'd reply on this one again
Looking through what has happened since 2003, when I wrote that
documentation thing, I decided to update a bit, translate it to english,
provide a small sample of how it can look, and changing the toolchain.

It is at

<http://lundin.homelinux.net/docbook_xml/target/html/dbdocumentation.html&gt;

/Bj�rn

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

---------------------------------
Here�s a new way to find what you're looking for - Yahoo! Answers