Lists: | pgsql-admin |
---|
From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
---|---|
To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Visio |
Date: | 2001-11-29 20:25:48 |
Message-ID: | 001001c17914$080b7540$de138f80@virginia.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
I need to create a diagram of our schema. I recently obtained a copy of Visio.
Has anyone used Visio to reverse engineer a model diagram from a Postgres database??
If not, can anyone recommend the best way to create a schema from Postgres without having to manually draw tables, add fields, etc...
Thanks
Jodi Kanter
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(804) 924-2846
jkanter(at)virginia(dot)edu
From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Visio |
Date: | 2001-11-29 21:11:23 |
Message-ID: | 20011129151123.A19079@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Thu, Nov 29, 2001 at 03:25:48PM -0500, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy of Visio.
> Has anyone used Visio to reverse engineer a model diagram from a Postgres database??
> If not, can anyone recommend the best way to create a schema from Postgres without having to manually draw tables, add fields, etc...
Fire up pgaccess, which is a Tcl/Tk graphical front end to PostgreSQL.
Connect to your database, and hit the 'Schema' tab. Add tables, and define
linkages by dragging and dropping. Remember to save the schema. (It's
stored in the database in a table named pga_schema)
It's not full featured, but it'll stay with the database it documents,
and follow changes. That's why I wrote it. ;-)
Ross
From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Jodi Kanter" <jkanter(at)virginia(dot)edu>, "Postgres Admin List" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Visio |
Date: | 2001-11-29 21:13:01 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGKEOODPAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
I've never used visio, but DBvisualizer works well if you have the key
relationships defined. You can get it free at http://www.minq.se
>Has anyone used Visio to reverse engineer a model diagram from a Postgres
database??
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Jodi Kanter" <jkanter(at)virginia(dot)edu>, "Postgres Admin List" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Visio |
Date: | 2001-11-29 21:18:28 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGEEOPDPAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Jodi-
I should have mentioned on that last post that you need to be running V7.1.x
of PGSQL & use the JDBC driver for JDBC 2. Somebody recently added a fix to
metadata in the JDBC driver that makes it all work, so earlier versions
won't cut it.
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
From: | Francisco Solari <fsolari(at)prosalud(dot)com(dot)ar> |
---|---|
To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Visio |
Date: | 2001-11-29 21:30:08 |
Message-ID: | 3C06A8E0.24E20672@prosalud.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
May I suggest Visible Analyst ? I'm using It and supports postgres
Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy
> of Visio.Has anyone used Visio to reverse engineer a model diagram
> from a Postgres database??If not, can anyone recommend the best way to
> create a schema from Postgres without having to manually draw tables,
> add fields, etc...ThanksJodi Kanter
> _______________________________
>
> Jodi L Kanter
> BioInformatics Database Administrator
> University of Virginia
> (804) 924-2846
> jkanter(at)virginia(dot)edu
>
> <?xml:namespace prefix = o ns =
> "urn:schemas-microsoft-com:office:office" />
>
Attachment | Content-Type | Size |
---|---|---|
fsolari.vcf | text/x-vcard | 237 bytes |
From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Visio |
Date: | 2001-11-29 22:43:53 |
Message-ID: | Pine.LNX.4.30.0111291741220.22323-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Thu, 29 Nov 2001, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy
> of Visio. Has anyone used Visio to reverse engineer a model diagram
> from a Postgres database?? If not, can anyone recommend the best way
> to create a schema from Postgres without having to manually draw
> tables, add fields, etc...
Not with Visio, but I think there's a new tool that can take a PostgreSQL
schema and generate an XML file for use in Dia (like Visio, but runs under
Gnome).
http://www.zort.ca/postgresql/
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
I am not afraid of tomorrow, for I have seen yesterday and I love today.
-- William Allen White
From: | Manuel Trujillo <manueltrujillo(at)dorna(dot)es> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | wiew's & cache |
Date: | 2001-11-30 10:21:28 |
Message-ID: | 20011130112128.A15793@dorna.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi.
Can Postgresql make a cache of different view's?
Is for a dynamic website.
Thank you.
--
Manuel Trujillo manueltrujillo(at)dorna(dot)es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864
From: | Mikhail Terekhov <terekhov(at)emc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Visio |
Date: | 2001-11-30 16:24:24 |
Message-ID: | 3C07B2B8.3000209@emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
It works fine with the latest Postgrs ODBC driver here.
Regards,
Mikhail
Jodi Kanter wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_000D_01C178EA.1F0F47A0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I need to create a diagram of our schema. I recently obtained a copy of Vis=
> io.=20
> Has anyone used Visio to reverse engineer a model diagram from a Postgres d=
> atabase??=20
> If not, can anyone recommend the best way to create a schema from Postgres =
> without having to manually draw tables, add fields, etc...
> Thanks
> Jodi Kanter
> _______________________________
> Jodi L Kanter
> BioInformatics Database Administrator
> University of Virginia
> (804) 924-2846
> jkanter(at)virginia(dot)edu
>
>
>
>
> ------=_NextPart_000_000D_01C178EA.1F0F47A0
> Content-Type: text/html; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffdd>
> <DIV><FONT face=3DArial size=3D2>I need to create a diagram of our schema. =
> I=20
> recently obtained a copy of Visio. </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Has anyone used Visio to reverse engineer =
> a model=20
> diagram from a Postgres database?? </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>If not, can anyone recommend the best way =
> to create=20
> a schema from Postgres without having to manually draw tables, add fields,=
> =20
> etc...</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Jodi Kanter</FONT></DIV>
> <DIV>
> <DIV class=3DSection1>
> <P class=3DMsoNormal><I><SPAN=20
> style=3D"FONT-FAMILY: Arial; FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt; ms=
> o-fareast-font-family: 'MS Mincho'">_______________________________<BR>Jodi=
> =20
> L Kanter<BR>BioInformatics Database Administrator<BR>University of=20
> Virginia<BR>(804) 924-2846<BR><A=20
> href=3D"mailto:jkanter(at)virginia(dot)edu">jkanter(at)virginia(dot)edu</A><BR=20
> style=3D"mso-special-character: line-break"><BR=20
> style=3D"mso-special-character: line-break"><?xml:namespace prefix =3D o ns=
> =3D=20
> "urn:schemas-microsoft-com:office:office"=20
> /><o:p></o:p></SPAN></I></P></DIV></DIV></BODY></HTML>
>
> ------=_NextPart_000_000D_01C178EA.1F0F47A0--
>
>