public inbox for [email protected]
help / color / mirror / Atom feedER diagram tools?
3+ messages / 3 participants
[nested] [flat]
* ER diagram tools?
@ 2024-02-09 19:11 Ron Watkins <[email protected]>
2024-02-09 20:55 ` Re: ER diagram tools? TIM CHILD <[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 19:11 ER diagram tools? Ron Watkins <[email protected]>
@ 2024-02-09 20:55 ` TIM CHILD <[email protected]>
2024-02-11 23:01 ` Re: ER diagram tools? GERALD CHEVES <[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-09 19:11 ER diagram tools? Ron Watkins <[email protected]>
2024-02-09 20:55 ` Re: ER diagram tools? TIM CHILD <[email protected]>
@ 2024-02-11 23:01 ` GERALD CHEVES <[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