Visio Like Tool....
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
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: rovero@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
-----Original Message-----
From: Thomas LeBlanc [mailto:thomasatiem@hotmail.com]
Sent: Friday, November 07, 2003 8:58 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Visio Like Tool....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 Erwin/Erx. It has an ODBC option.
Import Notes
Resolved by subject fallback
Hi,
I use Dezign from Datanamic (www.datanamic.com)
It's cheap, has drivers for tons of databases.
I also appreciated the high quality of support and the fact that you can
customize mamy thing.
There's a limited evaluation version!
Worth trying, believe me!
HTH,
Bir
-----Message d'origine-----
De : pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] De la part de Dann Corbit
Envoyé : vendredi, 7. novembre 2003 22:22
À : Thomas LeBlanc; pgsql-general@postgresql.org
Objet : Re: [GENERAL] Visio Like Tool....
-----Original Message-----
From: Thomas LeBlanc [mailto:thomasatiem@hotmail.com]
Sent: Friday, November 07, 2003 8:58 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Visio Like Tool....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 Erwin/Erx. It has an ODBC option.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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
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 LeBlancdia 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 majordomo@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 
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/
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
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)
Thank you Ben, that worked.
----- Original Message -----
From: "Ben" <bench@silentmedia.com>
To: "Julie May" <julie@ccorb.com>
Cc: <pgsql-general@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
Show quoted text
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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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.