pthurmond Posted September 4, 2007 Share Posted September 4, 2007 Hello, I am trying to do some database modeling of a Postgres db. I would like to create a script that can scour a given database and list all of the tables and their respective columns. In MySQL they have a "SHOW TABLES" command, but I have yet to find such a thing for Postgres. In the long run I would like to be able to visually model a db by running a php script. It may require using some other language with PHP to render it properly on the page. The visual model would include a visual representation of relations between tables. I have seen software for this but I can't afford to buy any and I am running on Mac OS X, so most applications for this won't work for my machine anyways. I can always try to take a dump file of the db, but I would prefer a way to dynamically update the model on the fly to represent the current db. Any ideas, suggestions, scripts I haven't found yet? Thanks, Patrick Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.