Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYXv5-00GUgV-Ln for pgsql-novice@arkaria.postgresql.org; Fri, 09 Feb 2024 20:56:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rYXv4-00CPu7-9Z for pgsql-novice@arkaria.postgresql.org; Fri, 09 Feb 2024 20:56:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYXv3-00CPrw-AG for pgsql-novice@lists.postgresql.org; Fri, 09 Feb 2024 20:56:22 +0000 Received: from resqmta-h1p-028591.sys.comcast.net ([2001:558:fd02:2446::9]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYXus-006Mw1-Ar for pgsql-novice@postgresql.org; Fri, 09 Feb 2024 20:56:14 +0000 Received: from resomta-h1p-028509.sys.comcast.net ([96.102.179.194]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resqmta-h1p-028591.sys.comcast.net with ESMTP id YSfzruFZH8K23YXujrb9L0; Fri, 09 Feb 2024 20:56:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1707512161; bh=Wfw3CkNGnNaKVCWpBy/3T7mNsuTPbc2I5Eu9ro9wSAM=; h=Received:Received:Date:From:To:Message-ID:Subject:MIME-Version: Content-Type:Xfinity-Spam-Result; b=ZY23JTzAR26SoDUuGaHyHExRIgYuiAJL9V0uVP7cpHlWm3NrdJqmxPcQG5RdhFLTt dDpgbPvkbfmqnGWGd60sELUfz9Wya59mull7zcmj85W/FEkL2S+oa+EfznDmV7cy8H uDy0zyJktSSKCoWt71gsooihdp6iRW3NigsxVZYVp3VkLldvzr6gnbRmd3JG98N44A EJ8fHqh2XS3KP/VvvwWQUnEQA2rLGDopaD1IuRHG6fSltHxpu8ivWUNVpMAuR8VOG/ VKDU4ZaP1N4CZiwUDP1y2XwHgYjea8wtNeUhi2Fao7BLz2wGlQ+09Go9EnNxgqO+6v 4MR4eojfsJP5Q== Received: from oxapp-hoc-05o.email.comcast.net ([96.118.243.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resomta-h1p-028509.sys.comcast.net with ESMTPS id YXuNrD9MsPghgYXuNrbNEh; Fri, 09 Feb 2024 20:55:39 +0000 Date: Fri, 9 Feb 2024 12:55:38 -0800 (PST) From: TIM CHILD To: pgsql-novice Message-ID: <1575236384.222264.1707512139163@connect.xfinity.com> In-Reply-To: References: Subject: Re: ER diagram tools? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_222263_53001466.1707512139099" X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.6-Rev55 X-Originating-IP: ::ffff:24.6.235.244 X-Originating-Client: open-xchange-appsuite X-CMAE-Envelope: MS4xfLotwaQx+xz/Uugoj9WnQ6tle3z0qOmQb0CYDb8SWPAZyNlbAULbDfmJ1mokMx+G851F6rZcIIAbLLMHGsSJZPU6dxMp0mun/MNL8WtfrBm2EdwYV6Gp 6xoc4ZzJcbfxH+/hkbVa2z6Bz+nr9jHF5n3ofzLUZ7b8AWpD3pIYGWP6nI8iJMslIoXiz9YIFSYfqLOyF3RRvuAzGmDrewpcwPxj3mVB64RhrhmcawIfZZNx List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_222263_53001466.1707512139099 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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: > =20 > 1. pgAdmin 4: > =20 > o Description: pgAdmin 4 is a powerful open-source administration and man= agement tool for PostgreSQL. It includes an ERD tool that allows you to des= ign 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: > =20 > o Description: Vertabelo is an online data modeling tool with ERD capabil= ities 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=3Dfree+ER+diagram+tools+for+Postgres > 3. Navicat: > =20 > 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=3Dfree+ER+diagram+tools+for+Postgres > 4. Visual Paradigm: > =20 > o Description: Visual Paradigm offers a comprehensive suite of modeling t= ools, 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=3Dfree+ER+diagram+tools+for+Postgres > 5. SqlDBM: > =20 > o Description: SqlDBM is an online database modeling tool that supports P= ostgreSQL. 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=3Dfree+ER+diagram+tools+for+Postgres > 6. ERDPlus: > =20 > o Description: ERDPlus is a free online tool for creating ERDs. While it= =E2=80=99s not PostgreSQL-specific, it=E2=80=99s easy to use and suitable f= or 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=3Dfree+ER+diagram+tools+for+Postgres > Remember to explore these tools and choose the one that best fits your ne= eds. Happy diagramming! =F0=9F=93=8A=F0=9F=94=8D > =20 > =20 >=20 >=20 > Learn more >=20 > 1pgadmin.org https://www.pgadmin.org/docs/pgadmin4/development/erd_tool.h= tml2bing.com https://bing.com/search?q=3Dfree+ER+diagram+tools+for+Postgres= 3youtube.com https://www.youtube.com/watch?v=3Do23LBJ-9jsU4youtube.com http= s://www.youtube.com/watch?v=3D2pxVCzRFGeg5youtube.com https://www.youtube.c= om/watch?v=3DmjQW2vO6_kY6dbmstools.com https://dbmstools.com/categories/dat= abase-diagram-tools/postgresql7dbdiagrams.com https://www.dbdiagrams.com/po= stgresql/online-er-diagram-postgresql-pagila-sample/8datensen.com https://w= ww.datensen.com/blog/docs/postgresql-er-diagram/ > =20 > 1of5 > =20 > Show learn more suggestions > =20 > =20 > =20 > New topic > New topic > =20 >=20 ------=_Part_222263_53001466.1707512139099 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =20 =20
Well Copilot says
=20
=20
=20
=20
=20
=20
=20
Copilot
=20
=20
=20
=20
=20
=20
Certainly! When it comes to creating Entity-Relati= onship Diagrams (ERDs) for PostgreSQL, = you have several options. Let me share some tools that you might find usefu= l:
=20
 
=20
    =20
  1. =20
    pgAdmin 4:
    =20
     
    =20
      =20
    • Description: pgAdmin 4 is a powerful ope= n-source administration and management tool for PostgreSQL. It includes an = ERD tool that allows you to design and visualize database tables and their = relationships.
      • =20
    • Features:=20
        =20
      • Design and visualize tables and relationships.
        • =20
      • Add notes to the diagram.
        • =20
      • Auto-align tables and links for cleaner visualization.<= /li>=20
      • Save and reopen diagrams.
        • =20
      • Generate SQL from the design.
        • =20
      • Create ERDs from existing databases, schemas, or tables= .
        • =20
      • =20
    • Reference: 1
      • =20
    2. =20
  2. =20
    Vertabelo:
    =20
     
    =20
      =20
    • Description: Vertabelo is an online data= modeling tool with ERD capabilities for PostgreSQL (as well as other datab= ases like MySQL, Microsoft SQL Server, Oracle, and SQLite).
      • =20
    • Features:=20
        =20
      • Conceptual, logical, and physical data model design.=20
      • Visualize relationships.
        • =20
      • =20
    • Reference: 2
      • =20
    3. =20
  3. =20
    Navicat:
    =20
     
    =20
      =20
    • Description: Navicat provides an ER diag= ram tool for visually designing conceptual, logical, and physical data mode= ls specifically for PostgreSQL.
      • =20
    • Features:=20
        =20
      • Design tables and relationships.
        • =20
      • =20
    • Reference: 2
      • =20
    4. =20
  4. =20
    Visual Paradigm:
    =20
     
    =20
      =20
    • Description: Visual Paradigm offers a co= mprehensive suite of modeling tools, including ERD capabilities for Postgre= SQL.
      • =20
    • Features:=20
        =20
      • Advanced modeling features.
        • =20
      • =20
    • Reference: 2
      • =20
    5. =20
  5. =20
    SqlDBM:
    =20
     
    =20
      =20
    • Description: SqlDBM is an online databas= e modeling tool that supports PostgreSQL. It allows you to create ERDs and = collaborate with team members.
      • =20
    • Features:=20
        =20
      • Collaborative design.
        • =20
      • =20
    • Reference: 2
      • =20
    6. =20
  6. =20
    ERDPlus:
    =20
     
    =20
      =20
    • Description: ERDPlus is a free online to= ol for creating ERDs. While it=E2=80=99s not PostgreSQL-specific, it=E2=80= =99s easy to use and suitable for various databases.
      • =20
    • Features:=20
        =20
      • Simple and intuitive interface.
        • =20
      • =20
    • Reference: 2
      • =20
    7. =20
=20
Remember to explore these tools and choose the one that best fi= ts your needs. Happy diagramming! =F0=9F=93=8A=F0=9F=94=8D
=20
 
=20
=20
=20
 
=20
=20
=20
=20
=20
Learn more
=20
=20
=20
1pgadmin= .org2bing.com3youtube.com4youtube.com5youtube.com6dbmstools.com7dbd= iagrams.com8datensen.com
=20
=20
=20
=20
 
=20
1of5
=20
 
=20
=20
Show learn more suggestions
=20
=20
 
=20
 
=20
=20
 
=20
=20
=20
=20
=20
New topic
=20
New topic
=20
=20
=20
=20
 
=20
=20
=20
=20
------=_Part_222263_53001466.1707512139099--