Thread: FREE ERD TOOL for POSTGRES ???
ERD tool for POSTGRES I checked the FAQ on this and was wondering what is the most easy to use ERD tool for POSTGRES, that is free, and can print out a diagram of the data model. I liked ERWIN in the past but not sure it works with POSTGRES. A tool with Round Trip engineering would be nice, but most important concern right now is simply being able to print out diagram of model and not have to install a ton of software to do it. warmest regards, Eric Sean Webber ---- On 22 Feb 2002 04:31:11, Joshua Drake (jd@commandprompt.com) wrote: > Hello, > > Just use an HTML form to post the data. Then use the include statement > and variables. > > > J > On Thu, 2002-02-21 at 16:26, Eric Webber wrote: > > > > > > Lets say I just want to update a record, > > how would I do that with LXP, I have gotten > > selects to work fine with the include, but what is the > > way to do updates, inserts and deletes ? > > do I have to do anything special ? > > > > regards, > > > > Eric Sean Webber > > > > > > > > ________________________________________________ > > Get your own "800" number > > Voicemail, fax, email, and a lot more > > http://www.ureach.com/reg/tag > > > > > > ---- On Thu, 21 Feb 2002, Joshua D. Drake (jd@commandprompt.com) > wrote: > > > > > > RedHat 2.4.7-10 #1 to be exact. > > > > > > > > > > Well first upgrade to the 2.4.9 kernel of redhat if you can :) > > > > > > > Now the problem is Error 6: Connection > > > > to persistent SQL database failed. > > > > > > This sounds like the database LXP is looking for has not been > created in > > > PostgreSQL.. > > > > > > John? > > > > > > > > > > > > > > this despite the sql_example select statement > > > > working fine manually via psql client. > > > > > > > > not sure what is wrong now. > > > > > > > > tried just about everything I could > > > > think of in the lxp.conf file, and restarted > > > > httpd each time after changing lxp.conf, > > > > and still cannot get sql_example.lxp to > > > > work. > > > > > > > > regards, > > > > > > > > Eric Sean Webber > > > > > > > > ________________________________________________ > > > > Get your own "800" number > > > > Voicemail, fax, email, and a lot more > > > > http://www.ureach.com/reg/tag > > > > > > > > > > > > ---- On Wed, 20 Feb 2002, John Worsley (jlx@commandprompt.com) > wrote: > > > > > > > > > On Wed, 20 Feb 2002, Eric Webber wrote: > > > > > >used the install script. > > > > > >Everything is as you indicate below > > > > > >except the exact line it used was: > > > > > > > > > > > ><IfDefine HAVE_PYTHON> > > > > > >LoadModule python_module modules/mod_python.so > > > > > >LoadModule lxp_module lib/apache/liblxp.so > > > > > ></IfDefine> > > > > > > > > > > > >why it put it there I have no idea, also > > > > > >the there is no libexec like in yours. > > > > > > > > > > Yes, this is what I was afraid of: you're using RH 7.x, right? > ;) > > > > For > > > > > some reason, their apxs distribution installs things a bit > > > > peculiarly. > > > > > > > > > > Just change that block to: > > > > > > > > > > <IfDefine HAVE_PYTHON> > > > > > LoadModule python_module modules/mod_python.so > > > > > </IfDefine> > > > > > LoadModule lxp_module lib/apache/liblxp.so > > > > > > > > > > I think in the future we're just going to manually modify this > file > > > > > rather > > > > > than trust apxs. ;) > > > > > > > > > > Regards, > > > > > Jw. > > > > > -- > > > > > John Worsley - Lead Programmer / Web Developer, Command Prompt, > Inc. > > > > > TheLinuxReview | Resources for Linux Users | > > > > > http://www.thelinuxreview.com/ > > > > > (503) 736-4609 | jlx@commandprompt.com | > > > > webmaster@thelinuxreview.com > > > > > > > > > > _______________________________________________ > > > > > lxp-general mailing list > > > > > lxp-general@commandprompt.com > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > lxp-general mailing list > > > > lxp-general@commandprompt.com > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > -- > > > -- > > > <COMPANY>CommandPrompt - http://www.commandprompt.com </COMPANY> > > > <PROJECT>TheLinuxReview - http://www.TheLinuxReview.com </PROJECT> > > > <WEBMASTER>LDP - http://www.linuxdoc.org </WEBMASTER> > > > -- > > > > > > _______________________________________________ > > > lxp-general mailing list > > > lxp-general@commandprompt.com > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag
If you have the primary & foreign key constraints set up, dbvisualizer works nicely. You'll need to have a JVM & the jdbc driver on your workstation, and set up the database for tcp/ip access. (Al of which is much simpler than it sounds.) -NickF > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Eric Webber > Sent: Monday, March 04, 2002 12:02 PM > To: lxp-general@commandprompt.com; pgsql-general@postgresql.org > Subject: [GENERAL] FREE ERD TOOL for POSTGRES ??? > > > ERD tool for POSTGRES > > I checked the FAQ on this and was wondering what is the most > easy to use ERD tool for POSTGRES, that is free, and can print > out a diagram of the data model. I liked ERWIN in the past > but not sure it works with POSTGRES. A tool with Round Trip > engineering would be nice, but most important concern right now > is simply being able to print out diagram of model and not have > to install a ton of software to do it. > > warmest regards, > > Eric Sean Webber > > > ---- On 22 Feb 2002 04:31:11, Joshua Drake (jd@commandprompt.com) wrote: > > > Hello, > > > > Just use an HTML form to post the data. Then use the include statement > > and variables. > > > > > > J > > On Thu, 2002-02-21 at 16:26, Eric Webber wrote: > > > > > > > > > Lets say I just want to update a record, > > > how would I do that with LXP, I have gotten > > > selects to work fine with the include, but what is the > > > way to do updates, inserts and deletes ? > > > do I have to do anything special ? > > > > > > regards, > > > > > > Eric Sean Webber > > > > > > > > > > > > ________________________________________________ > > > Get your own "800" number > > > Voicemail, fax, email, and a lot more > > > http://www.ureach.com/reg/tag > > > > > > > > > ---- On Thu, 21 Feb 2002, Joshua D. Drake (jd@commandprompt.com) > > wrote: > > > > > > > > RedHat 2.4.7-10 #1 to be exact. > > > > > > > > > > > > > Well first upgrade to the 2.4.9 kernel of redhat if you can :) > > > > > > > > > Now the problem is Error 6: Connection > > > > > to persistent SQL database failed. > > > > > > > > This sounds like the database LXP is looking for has not been > > created in > > > > PostgreSQL.. > > > > > > > > John? > > > > > > > > > > > > > > > > > > this despite the sql_example select statement > > > > > working fine manually via psql client. > > > > > > > > > > not sure what is wrong now. > > > > > > > > > > tried just about everything I could > > > > > think of in the lxp.conf file, and restarted > > > > > httpd each time after changing lxp.conf, > > > > > and still cannot get sql_example.lxp to > > > > > work. > > > > > > > > > > regards, > > > > > > > > > > Eric Sean Webber > > > > > > > > > > ________________________________________________ > > > > > Get your own "800" number > > > > > Voicemail, fax, email, and a lot more > > > > > http://www.ureach.com/reg/tag > > > > > > > > > > > > > > > ---- On Wed, 20 Feb 2002, John Worsley (jlx@commandprompt.com) > > wrote: > > > > > > > > > > > On Wed, 20 Feb 2002, Eric Webber wrote: > > > > > > >used the install script. > > > > > > >Everything is as you indicate below > > > > > > >except the exact line it used was: > > > > > > > > > > > > > ><IfDefine HAVE_PYTHON> > > > > > > >LoadModule python_module modules/mod_python.so > > > > > > >LoadModule lxp_module lib/apache/liblxp.so > > > > > > ></IfDefine> > > > > > > > > > > > > > >why it put it there I have no idea, also > > > > > > >the there is no libexec like in yours. > > > > > > > > > > > > Yes, this is what I was afraid of: you're using RH 7.x, right? > > ;) > > > > > For > > > > > > some reason, their apxs distribution installs things a bit > > > > > peculiarly. > > > > > > > > > > > > Just change that block to: > > > > > > > > > > > > <IfDefine HAVE_PYTHON> > > > > > > LoadModule python_module modules/mod_python.so > > > > > > </IfDefine> > > > > > > LoadModule lxp_module lib/apache/liblxp.so > > > > > > > > > > > > I think in the future we're just going to manually modify this > > file > > > > > > rather > > > > > > than trust apxs. ;) > > > > > > > > > > > > Regards, > > > > > > Jw. > > > > > > -- > > > > > > John Worsley - Lead Programmer / Web Developer, Command Prompt, > > Inc. > > > > > > TheLinuxReview | Resources for Linux Users | > > > > > > http://www.thelinuxreview.com/ > > > > > > (503) 736-4609 | jlx@commandprompt.com | > > > > > webmaster@thelinuxreview.com > > > > > > > > > > > > _______________________________________________ > > > > > > lxp-general mailing list > > > > > > lxp-general@commandprompt.com > > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > lxp-general mailing list > > > > > lxp-general@commandprompt.com > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > -- > > > > -- > > > > <COMPANY>CommandPrompt - http://www.commandprompt.com </COMPANY> > > > > <PROJECT>TheLinuxReview - http://www.TheLinuxReview.com </PROJECT> > > > > <WEBMASTER>LDP - http://www.linuxdoc.org </WEBMASTER> > > > > -- > > > > > > > > _______________________________________________ > > > > lxp-general mailing list > > > > lxp-general@commandprompt.com > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > > > > > ________________________________________________ > Get your own "800" number > Voicemail, fax, email, and a lot more > http://www.ureach.com/reg/tag > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
Hi Eric, There is also a list of ERD Tools which work with PostgreSQL at : http://techdocs.postgresql.org/oresources.php#erdtools :-) Regards and best wishes, Justin Clift Nick Fankhauser wrote: > > If you have the primary & foreign key constraints set up, dbvisualizer works > nicely. You'll need to have a JVM & the jdbc driver on your workstation, and > set up the database for tcp/ip access. (Al of which is much simpler than it > sounds.) > > -NickF > > > -----Original Message----- > > From: pgsql-general-owner@postgresql.org > > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Eric Webber > > Sent: Monday, March 04, 2002 12:02 PM > > To: lxp-general@commandprompt.com; pgsql-general@postgresql.org > > Subject: [GENERAL] FREE ERD TOOL for POSTGRES ??? > > > > > > ERD tool for POSTGRES > > > > I checked the FAQ on this and was wondering what is the most > > easy to use ERD tool for POSTGRES, that is free, and can print > > out a diagram of the data model. I liked ERWIN in the past > > but not sure it works with POSTGRES. A tool with Round Trip > > engineering would be nice, but most important concern right now > > is simply being able to print out diagram of model and not have > > to install a ton of software to do it. > > > > warmest regards, > > > > Eric Sean Webber > > > > > > ---- On 22 Feb 2002 04:31:11, Joshua Drake (jd@commandprompt.com) wrote: > > > > > Hello, > > > > > > Just use an HTML form to post the data. Then use the include statement > > > and variables. > > > > > > > > > J > > > On Thu, 2002-02-21 at 16:26, Eric Webber wrote: > > > > > > > > > > > > Lets say I just want to update a record, > > > > how would I do that with LXP, I have gotten > > > > selects to work fine with the include, but what is the > > > > way to do updates, inserts and deletes ? > > > > do I have to do anything special ? > > > > > > > > regards, > > > > > > > > Eric Sean Webber > > > > > > > > > > > > > > > > ________________________________________________ > > > > Get your own "800" number > > > > Voicemail, fax, email, and a lot more > > > > http://www.ureach.com/reg/tag > > > > > > > > > > > > ---- On Thu, 21 Feb 2002, Joshua D. Drake (jd@commandprompt.com) > > > wrote: > > > > > > > > > > RedHat 2.4.7-10 #1 to be exact. > > > > > > > > > > > > > > > > Well first upgrade to the 2.4.9 kernel of redhat if you can :) > > > > > > > > > > > Now the problem is Error 6: Connection > > > > > > to persistent SQL database failed. > > > > > > > > > > This sounds like the database LXP is looking for has not been > > > created in > > > > > PostgreSQL.. > > > > > > > > > > John? > > > > > > > > > > > > > > > > > > > > > > this despite the sql_example select statement > > > > > > working fine manually via psql client. > > > > > > > > > > > > not sure what is wrong now. > > > > > > > > > > > > tried just about everything I could > > > > > > think of in the lxp.conf file, and restarted > > > > > > httpd each time after changing lxp.conf, > > > > > > and still cannot get sql_example.lxp to > > > > > > work. > > > > > > > > > > > > regards, > > > > > > > > > > > > Eric Sean Webber > > > > > > > > > > > > ________________________________________________ > > > > > > Get your own "800" number > > > > > > Voicemail, fax, email, and a lot more > > > > > > http://www.ureach.com/reg/tag > > > > > > > > > > > > > > > > > > ---- On Wed, 20 Feb 2002, John Worsley (jlx@commandprompt.com) > > > wrote: > > > > > > > > > > > > > On Wed, 20 Feb 2002, Eric Webber wrote: > > > > > > > >used the install script. > > > > > > > >Everything is as you indicate below > > > > > > > >except the exact line it used was: > > > > > > > > > > > > > > > ><IfDefine HAVE_PYTHON> > > > > > > > >LoadModule python_module modules/mod_python.so > > > > > > > >LoadModule lxp_module lib/apache/liblxp.so > > > > > > > ></IfDefine> > > > > > > > > > > > > > > > >why it put it there I have no idea, also > > > > > > > >the there is no libexec like in yours. > > > > > > > > > > > > > > Yes, this is what I was afraid of: you're using RH 7.x, right? > > > ;) > > > > > > For > > > > > > > some reason, their apxs distribution installs things a bit > > > > > > peculiarly. > > > > > > > > > > > > > > Just change that block to: > > > > > > > > > > > > > > <IfDefine HAVE_PYTHON> > > > > > > > LoadModule python_module modules/mod_python.so > > > > > > > </IfDefine> > > > > > > > LoadModule lxp_module lib/apache/liblxp.so > > > > > > > > > > > > > > I think in the future we're just going to manually modify this > > > file > > > > > > > rather > > > > > > > than trust apxs. ;) > > > > > > > > > > > > > > Regards, > > > > > > > Jw. > > > > > > > -- > > > > > > > John Worsley - Lead Programmer / Web Developer, Command Prompt, > > > Inc. > > > > > > > TheLinuxReview | Resources for Linux Users | > > > > > > > http://www.thelinuxreview.com/ > > > > > > > (503) 736-4609 | jlx@commandprompt.com | > > > > > > webmaster@thelinuxreview.com > > > > > > > > > > > > > > _______________________________________________ > > > > > > > lxp-general mailing list > > > > > > > lxp-general@commandprompt.com > > > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > lxp-general mailing list > > > > > > lxp-general@commandprompt.com > > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > -- > > > > > -- > > > > > <COMPANY>CommandPrompt - http://www.commandprompt.com </COMPANY> > > > > > <PROJECT>TheLinuxReview - http://www.TheLinuxReview.com </PROJECT> > > > > > <WEBMASTER>LDP - http://www.linuxdoc.org </WEBMASTER> > > > > > -- > > > > > > > > > > _______________________________________________ > > > > > lxp-general mailing list > > > > > lxp-general@commandprompt.com > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ________________________________________________ > > Get your own "800" number > > Voicemail, fax, email, and a lot more > > http://www.ureach.com/reg/tag > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
> There is also a list of ERD Tools which work with PostgreSQL at : > http://techdocs.postgresql.org/oresources.php#erdtools If I quilify the search with these parameters: - OSS Why? Because I need it for an OSS project. - Reverse Engineering - Forward Engineering - Layered approach I want to be able to look only at tables related to e.g. customers, orders What are my options? I thought that maybe pgaccess could do most of this, but maybe I missed the documentation for it... -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@kakidata.dk
Hi Kaare, > > There is also a list of ERD Tools which work with PostgreSQL at : > > http://techdocs.postgresql.org/oresources.php#erdtools > > If I quilify the search with these parameters: > - OSS > Why? Because I need it for an OSS project. > - Reverse Engineering > - Forward Engineering > - Layered approach > I want to be able to look only at tables related to e.g. customers, orders > > What are my options? I guess you won't find such a powerfull OSS tool. The close you'll get is to ArgoUML (www.argouml.org) + UML2SQL (searchon freshmeat). []s, Fernando Lozano