Er Data Modeller for PostgreSQL

On 23/12/16 16:20, Günce Kaya wrote:

Hi All,

I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium
for postgresql and the tool has a modeller but I would like to display a
database modeller that belonging to a tables of an schema under a database.

If I use Navicat for modeller, I have to drag and drop whole tables which I
want to add to data modeller. So It's pretty manual process.

Is there any way to display an er modeller that show only chosen schema under
the database?

Any advice would be appreciated.

Regards,

--
Gunce Kaya

Try Schemaspy

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Stephen Davies schrieb am 23.12.2016 um 10:08:

I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium
for postgresql and the tool has a modeller but I would like to display a
database modeller that belonging to a tables of an schema under a database.

If I use Navicat for modeller, I have to drag and drop whole tables which I
want to add to data modeller. So It's pretty manual process.

Is there any way to display an er modeller that show only chosen schema under
the database?

Any advice would be appreciated.

Try Schemaspy

Scott Mead just blogged about using SchemaSpy with Postgres

http://www.openscg.com/2016/12/postgresql-schema-visualization/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

På fredag 23. desember 2016 kl. 06:50:54, skrev Günce Kaya <
guncekaya14@gmail.com <mailto:guncekaya14@gmail.com>>:
Hi All,  
I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium
for postgresql and the tool has a modeller but I would like to display a
database modeller that belonging to a tables of an schema under a database.
 
If I use Navicat for modeller, I have to drag and drop whole tables which I
want to add to data modeller. So It's pretty manual process. 
 
Is there any way to display an er modeller that show only chosen schema under
the database? 
 
Any advice would be appreciated. 
 
Regards,
 
-- 
Gunce Kaya

 
We use IDEA from IntelliJ: https://www.jetbrains.com/idea/
It features a nice DB-tool integrated (the commercial version only I think)
 

Database tools

Take advantage of intelligent coding assistance when editing SQL; connect to
live databases; run queries; browse and expert data; and even manage your
schemes in a visual interface–right from the IDE.

learn more <https://www.jetbrains.com/datagrip/features/&gt;
 
 
...which I think is an embeded version of their DataGrip
application: https://www.jetbrains.com/datagrip/
 

-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com&gt;
<https://www.visena.com&gt;

Hello Gunce,

Do you mean some sort of reverse engineering? Database Workbench supports that.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

From: Andreas Joseph Krogh
Sent: Friday, December 23, 2016 11:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Er Data Modeller for PostgreSQL

På fredag 23. desember 2016 kl. 06:50:54, skrev Günce Kaya <guncekaya14@gmail.com>:
Hi All,

I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium for postgresql and the tool has a modeller but I would like to display a database modeller that belonging to a tables of an schema under a database.

If I use Navicat for modeller, I have to drag and drop whole tables which I want to add to data modeller. So It's pretty manual process.

Is there any way to display an er modeller that show only chosen schema under the database?

Any advice would be appreciated.

Regards,

--
Gunce Kaya

Hi,

Thank you for your response.

This document is pretty good to use SchemasPy and thank you for your
sharing but I could not integrate with our postgres yet. I'm looking for a
database tool like Toad, DBVisualizer so on. It'll be more useful to me
now.

Regards,

Gunce Kaya

2016-12-23 12:44 GMT+03:00 Thomas Kellerer <spam_eater@gmx.net>:

Stephen Davies schrieb am 23.12.2016 um 10:08:

I'm looking for an ER Data Modeller tool for postgresql. I use Navicat

Premium
for postgresql and the tool has a modeller but I would like to display a
database modeller that belonging to a tables of an schema under a
database.

If I use Navicat for modeller, I have to drag and drop whole tables
which I
want to add to data modeller. So It's pretty manual process.

Is there any way to display an er modeller that show only chosen schema
under
the database?

Any advice would be appreciated.

Try Schemaspy

Scott Mead just blogged about using SchemaSpy with Postgres

http://www.openscg.com/2016/12/postgresql-schema-visualization/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Gunce Kaya

Maybe visual paradigm could help you, you can reverse and generate the
database in postgresql.

On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya <guncekaya14@gmail.com> wrote:

On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya <guncekaya14@gmail.com>
wrote:

Hi All,

I'm looking for an ER Data Modeller tool for postgresql. I use Navicat
Premium for postgresql and the tool has a modeller but I would like to
display a database modeller that belonging to a tables of an schema under a
database.

If I use Navicat for modeller, I have to drag and drop whole tables which
I want to add to data modeller. So It's pretty manual process.

Is there any way to display an er modeller that show only chosen schema
under the database?

Any advice would be appreciated.

Regards,

--
Gunce Kaya

Hi all,

Thank you for all of your suggestions. I found a tool that name is
DbSchema. It's simple and useful for using.

Regards,

--
Gunce Kaya

On Fri, 23 Dec 2016, Thomas Kellerer wrote:

Scott Mead just blogged about using SchemaSpy with Postgres

Thomas,

I've spent the past two days without success trying to get schemaSpy running here
and have found a solution that works quickly and easily: dbeaver
<http://www.dbeaver.com/&gt;. Yes, it's a GUI rather than CLI application but
it works ... and it's F/OSS under the GPL. Best of all worlds.

I downloaded the postgresql-jdbc driver and installed it in a couple of
places trying to make schemaSpy happy, and futzed with pg_hba.conf access
control. The dbeaver application downloaded and internally installed the
postgresql-jdbc driver it wants to use.

It took no time to figure out how to create, test, and establish a
connection to the databases and examine their E-R diagrams. They're now
saved as .png files.

Thanks very much for your pointer and my wishes for a healthy, happy, and
prosperous 2017 to you and all who responded to my question,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 12/28/2016 03:24 PM, Rich Shepard wrote:

On Fri, 23 Dec 2016, Thomas Kellerer wrote:

Scott Mead just blogged about using SchemaSpy with Postgres

Thomas,

I've spent the past two days without success trying to get schemaSpy
running here

An example from my machine that works:

aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u
postgres -db production -host localhost -dp
/home/aklaver/bin/postgresql-9.4.1212.jre6.jar -o s_spy

Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema
details........................................................................(2sec)
Writing/graphing summary..............(3sec)
Writing/diagramming
details.....................................................................(14sec)
Wrote relationship details of 69 tables/views to directory 's_spy' in 20
seconds.
View the results by opening s_spy/index.html

and have found a solution that works quickly and easily: dbeaver
<http://www.dbeaver.com/&gt;. Yes, it's a GUI rather than CLI application but
it works ... and it's F/OSS under the GPL. Best of all worlds.

Looks interesting.

I downloaded the postgresql-jdbc driver and installed it in a couple of
places trying to make schemaSpy happy, and futzed with pg_hba.conf access
control. The dbeaver application downloaded and internally installed the
postgresql-jdbc driver it wants to use.

It took no time to figure out how to create, test, and establish a
connection to the databases and examine their E-R diagrams. They're now
saved as .png files.

Thanks very much for your pointer and my wishes for a healthy, happy, and
prosperous 2017 to you and all who responded to my question,

Rich

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Wed, 28 Dec 2016, Adrian Klaver wrote:

An example from my machine that works:
aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u
postgres -db production -host localhost -dp
/home/aklaver/bin/postgresql-9.4.1212.jre6.jar -o s_spy

Adrian,

That's interesting. I specified my username, not postgres, since that's
how I access the databases from the psql CLI. But, since I've resolved the
issue to my satisfaction and deleted the schemaSpy subdirectory I've no
incentive to try again.

Time now to fill them thar tables with fake data so I can test as I
develop.

Happy new year to you,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

2016-12-29 1:03 GMT+01:00 Rich Shepard <rshepard@appl-ecosys.com>:

On Wed, 28 Dec 2016, Adrian Klaver wrote:

An example from my machine that works:

aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u
postgres -db production -host localhost -dp /home/aklaver/bin/postgresql-9.4.1212.jre6.jar
-o s_spy

Adrian,

That's interesting. I specified my username, not postgres, since that's
how I access the databases from the psql CLI. But, since I've resolved the
issue to my satisfaction and deleted the schemaSpy subdirectory I've no
incentive to try again.

Time now to fill them thar tables with fake data so I can test as I
develop.

Happy new year to you,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

​Hi I d'like to tell about Sql Power Architect (
http://www.sqlpower.ca/page/architect), an open-source software. Well
explained on the website but notice interessting feature such:
- comparing 2 database structure, and generating stmts to harmonize
differences in SQL or in liquibase ( http://www.liquibase.org/ )
​- infers the implicit FK with names
- multiplateform / multi database (absed on JDBC drivers)
- generate giant pdf for giant models

​Thanks for the link to the CLI shemaSpy, a pity the export is in html and
not reusable stuff like csv

On Thu, 29 Dec 2016, Nicolas Paris wrote:

Hi I'd like to tell about Sql Power Architect

Nicholas,

SPA was going to be my next re-examination after dbeaver. Since the latter
easily accomplished what I needed I stopped there.

Thanks for the reminder,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Thu, Dec 29, 2016 at 8:59 AM, Rich Shepard <rshepard@appl-ecosys.com>
wrote:

On Thu, 29 Dec 2016, Nicolas Paris wrote:

Hi I'd like to tell about Sql Power Architect

Nicholas,

SPA was going to be my next re-examination after dbeaver. Since the
latter
easily accomplished what I needed I stopped there.

I've actually used Sql Power Architect before as well. I like Schema Spy
because it's a quick read-only way to give me a fast report. SQL Power
Architect is nice because it's graphical and you can interact with the
DBA. I've also used DBVisualizer for this ( I actually love DBVisualizer
), but that tool is geared for interacting with the database and has
visualization as an extra. I'll have to try dbeaver, I've heard of it,
but, haven't used it.

Schema Spy is great, but, I do always have to come back and find the
exact command needed to kick it off, it's CLI is a bit over-complicated.

--Scott

Thanks for the reminder,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
--
Scott Mead
Sr. Architect
*OpenSCG <http://openscg.com&gt;*
http://openscg.com