Menu
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?
279
pgAdmin is the community client for using PostgreSQL. It is usually installed along with PostgreSQL. While psql is a simple command-line tool, pgAdmin is a graphical user interface that provides pretty much the same functionality.
STEP 1: CREATE NEW ERD Instead of clicking on the database name and then selecting to generate a new database you will instead click on the “Tools” dropdown at the top of the pgAdmin app window and select “Create New ERD.”
As a Postgres ER diagram tool, Navicat has the essential features for modeling your conceptual, logical, and physical data models. You can create complex ER Diagrams in Navicat using one of three standard notations: Crow's Foot, UML, or IDEF1x.
I eventually found: gem "rails-erd" Which produced the diagram in 2 minutes.
138
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
