public inbox for [email protected]help / color / mirror / Atom feed
ER diagram tools? 3+ messages / 3 participants [nested] [flat]
* ER diagram tools? @ 2024-02-09 19:11 Ron Watkins <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Ron Watkins @ 2024-02-09 19:11 UTC (permalink / raw) To: pgsql-novice Are there any decent free ER diagram tools for Postgres? -- Ron Watkins, K7DOG 602.743.5272 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ER diagram tools? @ 2024-02-09 20:55 TIM CHILD <[email protected]> parent: Ron Watkins <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: TIM CHILD @ 2024-02-09 20:55 UTC (permalink / raw) To: pgsql-novice Well Copilot says > Copilot > Certainly! When it comes to creating Entity-Relationship Diagrams (ERDs) for PostgreSQL, you have several options. Let me share some tools that you might find useful: > > 1. pgAdmin 4: > > o Description: pgAdmin 4 is a powerful open-source administration and management tool for PostgreSQL. It includes an ERD tool that allows you to design and visualize database tables and their relationships. > o Features: > + Design and visualize tables and relationships. > + Add notes to the diagram. > + Auto-align tables and links for cleaner visualization. > + Save and reopen diagrams. > + Generate SQL from the design. > + Create ERDs from existing databases, schemas, or tables. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html1 https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html > 2. Vertabelo: > > o Description: Vertabelo is an online data modeling tool with ERD capabilities for PostgreSQL (as well as other databases like MySQL, Microsoft SQL Server, Oracle, and SQLite). > o Features: > + Conceptual, logical, and physical data model design. > + Visualize relationships. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2 https://bing.com/search?q=free+ER+diagram+tools+for+Postgres > 3. Navicat: > > o Description: Navicat provides an ER diagram tool for visually designing conceptual, logical, and physical data models specifically for PostgreSQL. > o Features: > + Design tables and relationships. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2 https://bing.com/search?q=free+ER+diagram+tools+for+Postgres > 4. Visual Paradigm: > > o Description: Visual Paradigm offers a comprehensive suite of modeling tools, including ERD capabilities for PostgreSQL. > o Features: > + Advanced modeling features. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2 https://bing.com/search?q=free+ER+diagram+tools+for+Postgres > 5. SqlDBM: > > o Description: SqlDBM is an online database modeling tool that supports PostgreSQL. It allows you to create ERDs and collaborate with team members. > o Features: > + Collaborative design. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2 https://bing.com/search?q=free+ER+diagram+tools+for+Postgres > 6. ERDPlus: > > o Description: ERDPlus is a free online tool for creating ERDs. While itโs not PostgreSQL-specific, itโs easy to use and suitable for various databases. > o Features: > + Simple and intuitive interface. > o Reference: https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2 https://bing.com/search?q=free+ER+diagram+tools+for+Postgres > Remember to explore these tools and choose the one that best fits your needs. Happy diagramming! ๐๐ > > > > > Learn more > > 1pgadmin.org https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.html2bing.com https://bing.com/search?q=free+ER+diagram+tools+for+Postgres3youtube.com https://www.youtube.com/watch?v=o23LBJ-9jsU4youtube.com https://www.youtube.com/watch?v=2pxVCzRFGeg5youtube.com https://www.youtube.com/watch?v=mjQW2vO6_kY6dbmstools.com https://dbmstools.com/categories/database-diagram-tools/postgresql7dbdiagrams.com https://www.dbdiagrams.com/postgresql/online-er-diagram-postgresql-pagila-sample/8datensen.com https://www.datensen.com/blog/docs/postgresql-er-diagram/ > > 1of5 > > Show learn more suggestions > > > > New topic > New topic > > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ER diagram tools? @ 2024-02-11 23:01 GERALD CHEVES <[email protected]> parent: TIM CHILD <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: GERALD CHEVES @ 2024-02-11 23:01 UTC (permalink / raw) To: TIM CHILD <[email protected]>; +Cc: pgsql-novice --Apple-Mail-34E2282A-A478-4686-BF16-014FFD4F7836 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D= utf-8"></head><body dir=3D"auto">M<br><div dir=3D"ltr"><br><blockquote type=3D= "cite">On Feb 9, 2024, at 3:56 PM, TIM CHILD <[email protected]> w= rote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF= =BB=BF =20 <meta charset=3D"UTF-8">=20 =20 =20 <div style=3D"font-size: 12pt; font-family: helvetica,arial,sans-serif; co= lor: #333333;"> Well Copilot says </div>=20 <blockquote type=3D"cite">=20 <div class=3D"scroller scroller-enabled">=20 <div class=3D"scroller-positioner">=20 <div class=3D"content">=20 <div class=3D"main">=20 <div class=3D"header">=20 <div class=3D"header-label"> Copilot </div>=20 </div>=20 <div class=3D"message">=20 <div class=3D"content" tabindex=3D"0" aria-description=3D"">=20 <div class=3D"ac-container ac-adaptiveCard">=20 <div class=3D"ac-textBlock">=20 <div> Certainly! When it comes to creating <strong>Entity-Relatio= nship Diagrams (ERDs)</strong> for <strong>PostgreSQL</strong>, yo= u have several options. Let me share some tools that you might find useful: </div>=20 <div> </div>=20 <ol>=20 <li>=20 <div> <strong>pgAdmin 4</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: pgAdmin 4 is a powerful open= -source administration and management tool for PostgreSQL. It includes an ER= D tool that allows you to design and visualize database tables and their rel= ationships.</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Design and visualize tables and relationships.</li>=20 <li>Add notes to the diagram.</li>=20 <li>Auto-align tables and links for cleaner visualization.</= li>=20 <li>Save and reopen diagrams.</li>=20 <li>Generate SQL from the design.</li>=20 <li>Create ERDs from existing databases, schemas, or tables.= </li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-22-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://www.pgadmin.org/docs/pgadmin4/de= velopment/erd_tool.html" aria-label=3D"1: Reference" data-citationid=3D"7a49= 450c-234c-3f69-64c9-58ff1b247d7f-22"><sup class=3D"citation-sup" style=3D"li= ne-height: 0;">1</sup></a></li>=20 </ul> </li>=20 <li>=20 <div> <strong>Vertabelo</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: Vertabelo is an online data m= odeling tool with ERD capabilities for PostgreSQL (as well as other database= s like MySQL, Microsoft SQL Server, Oracle, and SQLite).</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Conceptual, logical, and physical data model design.</li= >=20 <li>Visualize relationships.</li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-37-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://bing.com/search?q=3Dfree+ER+diag= ram+tools+for+Postgres" aria-label=3D"2: Reference" data-citationid=3D"7a494= 50c-234c-3f69-64c9-58ff1b247d7f-37"><sup class=3D"citation-sup" style=3D"lin= e-height: 0;">2</sup></a></li>=20 </ul> </li>=20 <li>=20 <div> <strong>Navicat</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: Navicat provides an ER diagr= am tool for visually designing conceptual, logical, and physical data models= specifically for PostgreSQL.</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Design tables and relationships.</li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-51-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://bing.com/search?q=3Dfree+ER+diag= ram+tools+for+Postgres" aria-label=3D"2: Reference" data-citationid=3D"7a494= 50c-234c-3f69-64c9-58ff1b247d7f-51"><sup class=3D"citation-sup" style=3D"lin= e-height: 0;">2</sup></a></li>=20 </ul> </li>=20 <li>=20 <div> <strong>Visual Paradigm</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: Visual Paradigm offers a com= prehensive suite of modeling tools, including ERD capabilities for PostgreSQ= L.</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Advanced modeling features.</li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-65-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://bing.com/search?q=3Dfree+ER+diag= ram+tools+for+Postgres" aria-label=3D"2: Reference" data-citationid=3D"7a494= 50c-234c-3f69-64c9-58ff1b247d7f-65"><sup class=3D"citation-sup" style=3D"lin= e-height: 0;">2</sup></a></li>=20 </ul> </li>=20 <li>=20 <div> <strong>SqlDBM</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: SqlDBM is an online database= modeling tool that supports PostgreSQL. It allows you to create ERDs and co= llaborate with team members.</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Collaborative design.</li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-79-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://bing.com/search?q=3Dfree+ER+diag= ram+tools+for+Postgres" aria-label=3D"2: Reference" data-citationid=3D"7a494= 50c-234c-3f69-64c9-58ff1b247d7f-79"><sup class=3D"citation-sup" style=3D"lin= e-height: 0;">2</sup></a></li>=20 </ul> </li>=20 <li>=20 <div> <strong>ERDPlus</strong>: </div>=20 <div> </div>=20 <ul>=20 <li><strong>Description</strong>: ERDPlus is a free online too= l for creating ERDs. While it=E2=80=99s not PostgreSQL-specific, it=E2=80=99= s easy to use and suitable for various databases.</li>=20 <li><strong>Features</strong>:=20 <ul>=20 <li>Simple and intuitive interface.</li>=20 </ul> </li>=20 <li><a class=3D"tooltip-target" href=3D"https://www.pgadmin.or= g/docs/pgadmin4/development/erd_tool.html" data-citationid=3D"7a49450c-234c-= 3f69-64c9-58ff1b247d7f-93-group"><strong>Reference</strong>: </a><a cla= ss=3D"ac-anchor sup-target" href=3D"https://bing.com/search?q=3Dfree+ER+diag= ram+tools+for+Postgres" aria-label=3D"2: Reference" data-citationid=3D"7a494= 50c-234c-3f69-64c9-58ff1b247d7f-93"><sup class=3D"citation-sup" style=3D"lin= e-height: 0;">2</sup></a></li>=20 </ul> </li>=20 </ol>=20 <div> Remember to explore these tools and choose the one that best fit= s your needs. Happy diagramming! =F0=9F=93=8A=F0=9F=94=8D </div>=20 <div> </div>=20 </div>=20 </div>=20 <div class=3D"ad-container"> </div>=20 </div>=20 </div>=20 <div class=3D"learn-more-root">=20 <div class=3D"learn-more-control">=20 <h6 class=3D"learn-more">Learn more</h6>=20 </div>=20 <div class=3D"attribution-container">=20 <div class=3D"attribution-items"> <a class=3D"attribution-item" href=3D"https://www.pgadmin.org/docs= /pgadmin4/development/erd_tool.html" data-citationid=3D"8db850a9-38fa-36e4-3= 55b-b5606e56af83" aria-label=3D"ERD Tool =E2=80=94 pgAdmin 4 8.3 documentati= on"><span class=3D"badge">1</span><span class=3D"text-container">pgadmin.org= </span></a><a class=3D"attribution-item" href=3D"https://bing.com/search?q=3D= free+ER+diagram+tools+for+Postgres" data-citationid=3D"f4a24c23-1933-d3aa-f3= c4-eb65663b34dd" aria-label=3D"What=E2=80=99s the Best ER Diagram Tool for P= ostgreSQL?"><span class=3D"badge">2</span><span class=3D"text-container">bin= g.com</span></a><a class=3D"attribution-item" href=3D"https://www.youtube.co= m/watch?v=3Do23LBJ-9jsU" data-citationid=3D"b508ccaf-7338-2b4d-7bf5-fecf59f2= a6a6" aria-label=3D"Entity-Relationship Diagram (ERD) for PostgreSql using p= gAdmin4"><span class=3D"badge">3</span><span class=3D"text-container">youtub= e.com</span></a><a class=3D"attribution-item" href=3D"https://www.youtube.co= m/watch?v=3D2pxVCzRFGeg" data-citationid=3D"1991e385-3409-a0bc-6be9-872d2a67= 0cb7" aria-label=3D"pgAdmin: Entity-Relationship Diagram (ERD) Tool Demo - [= PostgreSQL Tutorial]"><span class=3D"badge">4</span><span class=3D"text-cont= ainer">youtube.com</span></a><a class=3D"attribution-item" href=3D"https://w= ww.youtube.com/watch?v=3DmjQW2vO6_kY" data-citationid=3D"12aeba2c-0098-dafb-= 24a8-0b331e09378e" aria-label=3D"Postgres PgAdmin ER diagram Example without= audio"><span class=3D"badge">5</span><span class=3D"text-container">youtube= .com</span></a><a class=3D"attribution-item" href=3D"https://dbmstools.com/c= ategories/database-diagram-tools/postgresql" data-citationid=3D"6241881a-020= 3-3d82-b3ec-034ef45b4b8e" aria-label=3D"Database diagram / Reverse Engineeri= ng tools for PostgreSQL"><span class=3D"badge">6</span><span class=3D"text-c= ontainer">dbmstools.com</span></a><a class=3D"attribution-item" href=3D"http= s://www.dbdiagrams.com/postgresql/online-er-diagram-postgresql-pagila-sample= /" data-citationid=3D"d02ffe46-af4b-c190-795f-de6d8f186e85" aria-label=3D"On= line ER diagrams | Pagila Sample | PostgreSQL ER diagram"><span class=3D"bad= ge">7</span><span class=3D"text-container">dbdiagrams.com</span></a><a class= =3D"attribution-item" href=3D"https://www.datensen.com/blog/docs/postgresql-= er-diagram/" data-citationid=3D"51cbe46c-bf29-7db5-79a2-26a0bc7764d4" aria-l= abel=3D"PostgreSQL ER Diagram | Graphics | Luna Modeler - Datensen"><span cl= ass=3D"badge">8</span><span class=3D"text-container">datensen.com</span></a>= </div>=20 </div>=20 </div>=20 <div class=3D"content footer has-bot-actions">=20 <div class=3D"container bordered"> </div>=20 <div class=3D"text"> 1of5 </div>=20 <div class=3D"indicator"> </div>=20 </div>=20 </div> Show learn more suggestions </div>=20 </div>=20 <div class=3D"fade top"> </div>=20 <div class=3D"fade bottom"> </div>=20 </div>=20 <div class=3D"divider"> </div>=20 <div class=3D"root">=20 <div class=3D"outside-left-container">=20 <div class=3D"button-compose-wrapper">=20 <div class=3D"button-compose-content">=20 <div class=3D"button-compose-text"> New topic </div>=20 </div> New topic </div>=20 </div>=20 <div class=3D"main-container">=20 <div class=3D"input-container as-ghost-placement">=20 <div class=3D"input-row"> </div>=20 </div>=20 </div>=20 </div>=20 </blockquote> =20 </div></blockquote>How about SQL Workbench for PostgreSQL?<div><br></div><di= v>phoenixnap.com/kb/postgresql-workbench</div><div><br></div><div>I=E2=80=99= ve also used Smartdraw and Lucidchart but there=E2=80=99s a subscription fee= .</div></body></html>= --Apple-Mail-34E2282A-A478-4686-BF16-014FFD4F7836-- ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-02-11 23:01 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-02-09 19:11 ER diagram tools? Ron Watkins <[email protected]> 2024-02-09 20:55 ` TIM CHILD <[email protected]> 2024-02-11 23:01 ` GERALD CHEVES <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox