Thread: 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.
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 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 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
> > 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.