pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Schema diagramming tool?
7+ messages / 5 participants
[nested] [flat]

* Schema diagramming tool?
@ 2012-09-04 16:35 Craig James <cjames@emolecules.com>
  2012-09-04 20:57 ` Re: Schema diagramming tool? Bob Lunney <bob_lunney@yahoo.com>
  2012-09-05 04:48 ` Re: Schema diagramming tool? Sergey Konoplev <gray.ru@gmail.com>
  2012-09-05 05:47 ` Re: Schema diagramming tool? Thomas Markus <t.markus@proventis.net>
  2012-09-18 11:12 ` Re: Schema diagramming tool? Cédric Villemain <cedric@2ndquadrant.com>
  0 siblings, 4 replies; 7+ messages in thread

From: Craig James @ 2012-09-04 16:35 UTC (permalink / raw)
  To: pgsql-admin

Can anyone recommend a good tool for producing a good drawing of an
existing database schema?  I don't need a design tool, but rather one that
can take an existing schema and produce a nice diagram that can be further
edited and "beautified."  I want something I can print and hang on the wall
as a reference document for developers writing code and SQL.

Thanks,
Craig

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
@ 2012-09-04 20:57 ` Bob Lunney <bob_lunney@yahoo.com>
  3 siblings, 0 replies; 7+ messages in thread

From: Bob Lunney @ 2012-09-04 20:57 UTC (permalink / raw)
  To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin

SchemaSpy is kind of handy. 

Bob

Sent from my iPhone

On Sep 4, 2012, at 11:35 AM, Craig James <cjames@emolecules.com> wrote:

> Can anyone recommend a good tool for producing a good drawing of an existing database schema?  I don't need a design tool, but rather one that can take an existing schema and produce a nice diagram that can be further edited and "beautified."  I want something I can print and hang on the wall as a reference document for developers writing code and SQL.
> 
> Thanks,
> Craig
> 




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
@ 2012-09-05 04:48 ` Sergey Konoplev <gray.ru@gmail.com>
  2012-09-05 15:26   ` Re: Schema diagramming tool? Craig James <cjames@emolecules.com>
  3 siblings, 1 reply; 7+ messages in thread

From: Sergey Konoplev @ 2012-09-05 04:48 UTC (permalink / raw)
  To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin

On Tue, Sep 4, 2012 at 8:35 PM, Craig James <cjames@emolecules.com> wrote:
> Can anyone recommend a good tool for producing a good drawing of an existing
> database schema?  I don't need a design tool, but rather one that can take
> an existing schema and produce a nice diagram that can be further edited and
> "beautified."  I want something I can print and hang on the wall as a
> reference document for developers writing code and SQL.

I used to use PostgreSQL Maestro for this purpose. Its Designer tool
is quite nice.

>
> Thanks,
> Craig
>



-- 
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
  2012-09-05 04:48 ` Re: Schema diagramming tool? Sergey Konoplev <gray.ru@gmail.com>
@ 2012-09-05 15:26   ` Craig James <cjames@emolecules.com>
  2012-09-06 11:26     ` Re: Schema diagramming tool? Sergey Konoplev <gray.ru@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Craig James @ 2012-09-05 15:26 UTC (permalink / raw)
  To: Sergey Konoplev <gray.ru@gmail.com>; +Cc: pgsql-admin

On Tue, Sep 4, 2012 at 9:48 PM, Sergey Konoplev <gray.ru@gmail.com> wrote:
> On Tue, Sep 4, 2012 at 8:35 PM, Craig James <cjames@emolecules.com> wrote:
>> Can anyone recommend a good tool for producing a good drawing of an existing
>> database schema?  I don't need a design tool, but rather one that can take
>> an existing schema and produce a nice diagram that can be further edited and
>> "beautified."  I want something I can print and hang on the wall as a
>> reference document for developers writing code and SQL.
>
> I used to use PostgreSQL Maestro for this purpose. Its Designer tool
> is quite nice.

They don't say anywhere on their web site which platforms they
support.  Is this a Windows-only application?

Thanks,
Craig




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
  2012-09-05 04:48 ` Re: Schema diagramming tool? Sergey Konoplev <gray.ru@gmail.com>
  2012-09-05 15:26   ` Re: Schema diagramming tool? Craig James <cjames@emolecules.com>
@ 2012-09-06 11:26     ` Sergey Konoplev <gray.ru@gmail.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Sergey Konoplev @ 2012-09-06 11:26 UTC (permalink / raw)
  To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin

On Wed, Sep 5, 2012 at 7:26 PM, Craig James <cjames@emolecules.com> wrote:
>> I used to use PostgreSQL Maestro for this purpose. Its Designer tool
>> is quite nice.
>
> They don't say anywhere on their web site which platforms they
> support.  Is this a Windows-only application?

I think it is. I worked with it on Windows. However it will probably
work with Wine on Linux, I have not tried.

BTW as I remember Squirrel SQL has diagramming too.

-- 
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
@ 2012-09-05 05:47 ` Thomas Markus <t.markus@proventis.net>
  3 siblings, 0 replies; 7+ messages in thread

From: Thomas Markus @ 2012-09-05 05:47 UTC (permalink / raw)
  To: pgsql-admin

Hi,

give db visualizer a try.

best regards
Thomas

Am 04.09.2012 18:35, schrieb Craig James:
> Can anyone recommend a good tool for producing a good drawing of an 
> existing database schema?  I don't need a design tool, but rather one 
> that can take an existing schema and produce a nice diagram that can 
> be further edited and "beautified."  I want something I can print and 
> hang on the wall as a reference document for developers writing code 
> and SQL.
>
> Thanks,
> Craig
>





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Schema diagramming tool?
  2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
@ 2012-09-18 11:12 ` Cédric Villemain <cedric@2ndquadrant.com>
  3 siblings, 0 replies; 7+ messages in thread

From: Cédric Villemain @ 2012-09-18 11:12 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Craig James <cjames@emolecules.com>

Le mardi 4 septembre 2012 18:35:20, Craig James a écrit :
> Can anyone recommend a good tool for producing a good drawing of an
> existing database schema?  I don't need a design tool, but rather one that
> can take an existing schema and produce a nice diagram that can be further
> edited and "beautified."  I want something I can print and hang on the wall
> as a reference document for developers writing code and SQL.

postgresql_autodoc is old and simple, and works (even for complex database). 

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

Attachments:

  signature.asc (application/pgp-signature, 489B) download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2012-09-18 11:12 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-04 16:35 Schema diagramming tool? Craig James <cjames@emolecules.com>
2012-09-04 20:57 ` Bob Lunney <bob_lunney@yahoo.com>
2012-09-05 04:48 ` Sergey Konoplev <gray.ru@gmail.com>
2012-09-05 15:26   ` Craig James <cjames@emolecules.com>
2012-09-06 11:26     ` Sergey Konoplev <gray.ru@gmail.com>
2012-09-05 05:47 ` Thomas Markus <t.markus@proventis.net>
2012-09-18 11:12 ` Cédric Villemain <cedric@2ndquadrant.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox