Visio Like Tool....

[Thomas LeBlanc]

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

[P.J. \Josh\ Rovero]

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: [phone] or 442-4355 Waterford CT 06385
************************************************** *********************
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[bob parker]

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

[Joshua D. Drake]

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.
[phone] - [e-mail] - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org

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

[Rich Shepard]

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) | [e-mail]
http://www.appl-ecosys.com/

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

[Julie May]

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)

[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

[Julie May]

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

[Randolf Richardson, DevNet SysOp 29]

> 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 - [e-mail]
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.

[Randolf Richardson, DevNet SysOp 29]

> 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 - [e-mail]
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.