Обсуждение: Documenting PGSQL database.
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.
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 wayof documenting the schema of PGSQL database so that I can get a printed copyof 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 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 wayof documenting the schema of PGSQL database so that I can get a printed copyof 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
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:
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 wayof documenting the schema of PGSQL database so that I can get a printed copyof the same.Hmm, I did not get my own post , so I thought I'd reply on this one againLooking through what has happened since 2003, when I wrote thatdocumentation 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örnBjörn Lundinb dot f dot lundin at gmail dot com
Heres a new way to find what you're looking for - Yahoo! Answers
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