Jump to content

visual database representation for psql?


Jago6060

Recommended Posts

Hi all.  I have a database that I didn't create, it was made by the developers of an open source program that my company uses.  I haven't been able to find a data model for the DB, so I was wondering if there was some sort of tool that will visually show the relationships in a DB.  Or a program that will allow me to upload a DB, and it will show me the visual representation.  Any ideas?

Link to comment
https://forums.phpfreaks.com/topic/172158-visual-database-representation-for-psql/
Share on other sites

Not sure if this is what you're looking for: http://phppgadmin.sourceforge.net/

 

Not quite.  I'm looking for something like what MSAccess does.  Where it shows your tables and puts a line between related fields.  Basically a database map...

 

TableA.field1-------TableB.field1

|

------TableC.field1

 

 

Not the best representation, but it illustrates my point.

I personally use Aqua Data Studio for this. It's a commercial product, but it's a nice tool and you can use the demo long enough to figure it out.

http://www.aquafold.com/

 

Also found powerArchitect that appears to be OS and do what you need.

 

http://www.sqlpower.ca/page/architect

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.