FREE ERD TOOL for POSTGRES ???

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

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 (search on freshmeat).

[]s, Fernando Lozano

Does ArgoUML fully support all of Postgres' Data Types out of
the box [as ERWIN supports Oracle for example] and ability show
cardinality etc and reverse engineer etc with Postgres, all the
relationships, constraints etc ?

warmest regards,

Eric Sean Webber

________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag

---- On Mon, 11 Mar 2002, Fernando Lozano (fsl@centroin.com.br)
wrote:

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 (search on

freshmeat).