Postgres Pro
Downloads
Home   >   mailing lists

Thread: Documenting PGSQL database.

Documenting PGSQL database.

From
RPK
Date:
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#a9886934
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Documenting PGSQL database.

From
Björn Lundin
Date:

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



Re: Documenting PGSQL database.

From
"imageguy"
Date:
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.

Re: Documenting PGSQL database.

From
Björn Lundin
Date:

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 




/Björn

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



Re: Documenting PGSQL database.

From
Ashish Karalkar
Date:
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 




/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

Re: Documenting PGSQL database.

From
Stefan Berglund
Date:
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