Обсуждение: Visio
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@virginia.edu
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@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
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@virginia.edu<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Вложения
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, addfields, 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
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@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
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
Hi. Can Postgresql make a cache of different view's? Is for a dynamic website. Thank you. -- Manuel Trujillo manueltrujillo@dorna.es Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864
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@virginia.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@virginia.edu">jkanter@virginia.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-- > >