Skip site navigation (1) Skip section navigation (2)

Checking referencial integrity

From: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Checking referencial integrity
Date: 2010-09-21 10:56:06
Message-ID: 1285066566.2169.28.camel@machielr-laptop (view raw or flat)
Thread:
Lists: pgsql-novice
Good day all

        
                I am hoping that someone can perhaps assist in the
following as I don't have as much experience in postgres as most people
on this list.

    

                I need to verify and check the referencial integrity of
a database containing over 700 tables.

                In order to do this I have been trying to find a way to
create a visual digram of all the references / dependencies between
tables (foreign keys,etc...) however doing this manually is taking way
too long.

                After trying to google for better alternatives, I found
a couple of gui frontends to assist in this, however I have been unable
to find one that works.

                  Either they merely create reports without graphical
views (like pgdesigner) and crashes whenever you want to do anything
else with it or they do not even want to run on my machine due to
millions of dependencies of library version differences,etc....


                   This database is but one of many databases I need to
do this for thus manually doint this will be a horrible task.


                    Does anybody perhaps know whether there is a tool
out there that can be used to reverse engineer the database structures,
references,etc... and then output it into graphical form.

                    Otherwise, if not, I am looking for a linux (ubuntu)
package that can be used to easily create these type of diagrams. 


                    I would really appreciate the help here as it will
save me lots of time.


Regards
Machiel

pgsql-novice by date

Next:From: Jens-Christoph BrendelDate: 2010-09-21 15:52:40
Subject: Re: PostgreSQL article online - PDF
Previous:From: Frank BaxDate: 2010-09-21 10:55:25
Subject: Re: Test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group