Обсуждение: Visio

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/

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--
>
>