By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,299 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Visio Like Tool....

P: n/a
Is there a tool for designing databases(ERD to data Design) and being able
to generate scripts or databases from the tool.

Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.

Thanks,
Thomas LeBlanc

__________________________________________________ _______________
Concerned that messages may bounce because your Hotmail account is over
limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
I recommend dia, and there are some tools around
to actual make schema from the diagrams and/or
vice versa.

Thomas LeBlanc wrote:
Is there a tool for designing databases(ERD to data Design) and being
able to generate scripts or databases from the tool.

Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.

--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: ro****@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
************************************************** *********************
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

P: n/a
On Sat, 8 Nov 2003 03:57, Thomas LeBlanc wrote:
Is there a tool for designing databases(ERD to data Design) and being able
to generate scripts or databases from the tool.

Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.

Thanks,
Thomas LeBlanc

dia and dia2sql. I think I got the latter from Debian non-free.
Use the UML option in dia, and dia2sql will generate your sql for you.

Bob

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #3

P: n/a
bob parker wrote:
On Sat, 8 Nov 2003 03:57, Thomas LeBlanc wrote:

Is there a tool for designing databases(ERD to data Design) and being able
to generate scripts or databases from the tool.

Eclipse has an ERD plugin that works with PostgreSQL

www.eclispe.org
Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.

Thanks,
Thomas LeBlanc

dia and dia2sql. I think I got the latter from Debian non-free.
Use the UML option in dia, and dia2sql will generate your sql for you.

Bob

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #4

P: n/a
On Tue, 11 Nov 2003, Joshua D. Drake wrote:
Eclipse has an ERD plugin that works with PostgreSQL

www.eclispe.org


It's called "Clay" and written by the fine folks at www.azzurri.jp. I just
started using it and I like it very much.

Rich

Dr. Richard B. Shepard, President

Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
http://www.appl-ecosys.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #5

P: n/a
Is it possible to use an array as a parameter to a pl/pgsql function. I am
running version 7.3 and don't have the time right now to upgrade.If it is
possible, how do you iterate through the array? For example:

phpVariable[0]=1;
phpVariable[1]=2;
phpVariable[2]=3;

some_pl/pgsql_function(phpVariable?)
how do you access phpVariable[2] within the function?

Thanks.

Julie
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #6

P: n/a
Ben
On Mon, 17 Nov 2003, Julie May wrote:
Is it possible to use an array as a parameter to a pl/pgsql function. I am
running version 7.3 and don't have the time right now to upgrade.If it is
possible, how do you iterate through the array? For example:

CREATE or REPLACE FUNCTION foo(integer[]) RETURNS int AS
'DECLARE
a alias for $1;
index integer := 1;
total integer := 0;
BEGIN
WHILE a[index] > 0
LOOP
total := total + a[index];
index := index + 1;
END LOOP;

RETURN total;
END;
' LANGUAGE 'plpgsql';

test=> select foo('{1,2}');
foo
-----
3
(1 row)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #7

P: n/a
Thank you Ben, that worked.

----- Original Message -----
From: "Ben" <be***@silentmedia.com>
To: "Julie May" <ju***@ccorb.com>
Cc: <pg***********@postgresql.org>
Sent: Monday, November 17, 2003 3:17 PM
Subject: Re: [GENERAL] arrays as parameters to pl/pgsql functions

On Mon, 17 Nov 2003, Julie May wrote:
Is it possible to use an array as a parameter to a pl/pgsql function. I am running version 7.3 and don't have the time right now to upgrade.If it is possible, how do you iterate through the array? For example:

CREATE or REPLACE FUNCTION foo(integer[]) RETURNS int AS
'DECLARE
a alias for $1;
index integer := 1;
total integer := 0;
BEGIN
WHILE a[index] > 0
LOOP
total := total + a[index];
index := index + 1;
END LOOP;

RETURN total;
END;
' LANGUAGE 'plpgsql';

test=> select foo('{1,2}');
foo
-----
3
(1 row)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #8

P: n/a
> Is there a tool for designing databases(ERD to data Design) and being
able to generate scripts or databases from the tool.

Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.


I like Druid, which is open source and written in Java so it will run
on all Operating Systems:

Druid, The Database Manager
http://sourceforge.net/projects/druid/

This one lets you create multiple E/R Views, and in addition to
generating SQL Code for you it will also create Java classes, complete PDF
documentation, and many other things. It has direct support for PostgreSQL,
and some others.

--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.

Nov 12 '05 #9

P: n/a
> Is there a tool for designing databases(ERD to data Design) and being
able to generate scripts or databases from the tool.

Visio does a good job, but does not have a driver for PostgreSQL. The
scripts have to be modified before executing.


I like Druid, which is open source and written in Java so it will run
on all Operating Systems:

Druid, The Database Manager
http://sourceforge.net/projects/druid/

This one lets you create multiple E/R Views, and in addition to
generating SQL Code for you it will also create Java classes, complete PDF
documentation, and many other things. It has direct support for PostgreSQL,
and some others.

--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.

Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.