pgadmin 4 (or db visualiser) entity relation diagram

postgresql pgadmin dbvisualizer entity-relationship-model
Mel picture Mel · Feb 1, 2017 · Viewed 10.8k times · Source

How do you make an entity relation diagram using pgAdmin v4 or DB Visualizer or any other open source tool?

PG Admin There are lots of explainers for pgadmin III but they suggest that there should be a tab called 'graphical query builder under the tools/query menu. There isnt. It has since been explained that this feature no longer exists in pgadmin.

Objective I have 70 tables in my schema and I'm trying to find instructions for how to generate a graphical representation of the relations between them.

Does anyone know where to find instructions for how to do this with an open source tool (written in clear english)?

DB Visualizer I've separately downloaded DB Visualiser on my mac, but I cant find instructions for how to locate and connect my database, but the table values don't make sense to me. I get a successful connection message showing and then I can see the name of the db (that I enter in the wizard) on the connections tab, but all of the menus underneath that are gibberish - none of them show my schema.

Does anyone know how to generate an entity relation diagram from Postgres on a mac?

Answer

Mel picture Mel · Feb 4, 2017

I eventually found: gem "rails-erd" Which produced the diagram in 2 minutes.

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later I opened the UI and create the server …

Read More
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove table. Ok, now I …

Read More