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 1rZIq3-003Pcg-5S for pgsql-novice@arkaria.postgresql.org; Sun, 11 Feb 2024 23:02:19 +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 1rZIq1-005aox-Rx for pgsql-novice@arkaria.postgresql.org; Sun, 11 Feb 2024 23:02:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZIq1-005aop-02 for pgsql-novice@lists.postgresql.org; Sun, 11 Feb 2024 23:02:17 +0000 Received: from sonic311-15.consmr.mail.bf2.yahoo.com ([74.6.131.125]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rZIpx-006GqU-OY for pgsql-novice@postgresql.org; Sun, 11 Feb 2024 23:02:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=verizon.net; s=a2048; t=1707692531; bh=miRqKgQqX4+UeOMdvVmu4ssRd/SUPYBnxNxa9jNN3y0=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From:Subject:Reply-To; b=f12Ns+PrrHQcrMJq4cWeGWCDRQ5QOJPd0SB6UppM6NGsweokvLxCY64ydCBPCCwa5ttnO7NP6fPKajC78YkAxC2x3eIxWxr0W4jS/9lk6OVP6xXRdL4+ox9UigKEP3j6oeHuvBzyvTTIFnuWDF3BPHZ890ZtoSF5oiZ/172zvwOUuWSxNuU0b2lXnuY2ovloCFdQd8al56LoMG/nTFn34Q6JNyeAuOFzG9ZWtDnO8VeL0155ogdhQUgUCJgy4gg/FQ24aVa/6KdXrnZTSYhLhLXRVj/O7uqEf7we/VH+Iw4KPVS7QXwxWkc2seyVCz49ziyOzySe2Um8cwpIjBWIlA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1707692531; bh=dClc+BMTTRs0ad6jmeAjq1juDAr+C0z1YhLPcgFaaKP=; h=X-Sonic-MF:Subject:From:Date:To:From:Subject; b=PBGAikMRDqVUa2H8CMEs3eI5iEBVRkqigc2+jllSNLBtgnVe8hDu2ULXnCvb5JxkrPASfRMhXxn1KRCJ0ZzQzmaun1Oce2ezojUx1cLs+ixzBPIzgqKe2E3t3Ka39yejKE6Y4tTjK5o2tSGGaN3UyNxGvByfp3Gsj+sB7WXanf6SwRCkUWAkVViVmFc8Cjhs7TDtpF66DhKLIKaI2zM4tsMb3OeST/tNbFVgyX7yEItp9bdxGW49fnkL+toEfXGw/GwEgyaF50V5HGBgGPh01R5/bJCfDMGY5OtAd9qYbNlZJz3TK5rj6rI7BFo114v1vNFe22ZBiuEcr0fV7pXvMw== X-YMail-OSG: 1o2z07IVM1nUzruQFf4nNYM8EXhmTidVGhhY9dd8uOPvRPviUlkdYSYTYXfwwER oZVRZFu4a9ISDfjYi8zYFctitLcxdvweBv6zUBKIBQ0U4pG72A9hypdj7WM8lOenvYM0YXRcq5EJ RJtkzzmqRjZQZt8dghHkgmzzwla.YL3_A3Qj5AI7Az4Yme0OZrWEnY6CQU9h5gT0fOl9NLrGXtSb 9M6ZYMFs1O4zUQjNCB2Yqj3yth0CWcZ2IXHyslZ_lQ3IUGD9epk4YqwzLIdRkCb8lwc.0kVkIXiu 8Q.wCbEK1h45Wl_fw4WfXk4sI9APsUAhoInJafLKGYj36O.5ElfDXjMP9KJ1E9I8FC1Vg1OO.1jM BvLajLTTdl4s9JWGqaJREQPvDXw0IFWoBO_s6k4P3188irj7AnLKfIuQnzd1H7ssqekeuQ4hu70F hk.U226SNYFbCiUKxx9rv9gEIc7fb2Ksff_Wa58G0JYe3sRNORQNCnyreUTJBlHv5p.TxFefYExJ NCS3MwmNNPkL8AfHvvH0eV0HD83iAS.Wh2wsmfQjrlYsbslnaah_A2rGStSLK.VNVAxPHpUrBpcH dtmaeDzIV.aJcXUWYIbVqmcYeu1qO0EKzPDixZMsVD73KffIPPndpw6QguhjLW2rk.oGdXfTU8k1 sXjDeBQ_EkLv4ANw1o8F6mBz22c_yScL8vYJcnOHzcEFdYeBwZRZ8OBdbPqSkRxSUuTNSTIsNgd5 XzKhuezltEO3WC1M3Sm6e6bcrBVKW6gcgyIyyR6COOwk3Q2TZ85hmERdaWaDycwbT_oH9qNOGy7C R2MNWVm8rCZhNMQUSTrChCNxASY43LmDVlrEPjSCbGYG0SOArklrf2PqPtSKUDgEyJz9DO5lN5uv FHnTZ4f.LA6.jkDtFkV.5NXyhgmimF_kLLFdVeR7bVSnz9vwPkqsL9TFbs_5K_Lgy3O6VTEs7wia 4ZtAAwjrDrisHMqvyiCEM80.tJh6ViQKEVgBiMx6HaMr1LdNEnR_Eps3FitvLqu94SetR.cGya8N NlNghph36V.0gToFF.S4qO3tatU4kJMvRBLx_djjJTTatAOsspPMf.gsesGuom9cw70QK4Yz0wjl 7otSFIPcUQGdOUbsF67zjMefUB3Y87JcwaZeTFWR81d5TWLP.0VbOPbTL0i1xH0ufCew9LlTwfVV 4JG5By105nSMRxGWPFi3zAHPKq8UswKtTQW0hMYIozVxJZ8y8ZDzP6Qgp4iT2MvY9kmb6mr362Oc UZWmbSow2BDJn5UA.Y7mKvQx63l_PhFLRTDxdjlwFGNYv49rhpm_.KbD.S18QTdXfMbX9At2reOy pjnekMifU90Gyg5YRmmJDi8TM7.HH138sAnf7rScW..niBUt2lNrEiiUpPGsXWifKaiNtQfgf6vW zL87acuD8y2dnaBeVI_9D8o73tskdXgN_TRTP3qyxUVmbgqPIGhV9Io.sacsQDCpEeCrFTTckws9 z_CpY1ciPIjMe5iQ1YCoJUZsLhKY2EmzMf3xnTyhfGihiNxPhuAuHNKo1cHNY4BjNPTwyfdOQ_PL K1PxaOwj56QE7sCmPr5oZxAU6BCHb6x7OpkluDgx6x2SvqshQ3_TK_ePGwojT8roZW4q.fxxLgYk CsGRCUtOnWmQuSidKgVVHPwom_rCjf49IB48NPkiF3zQrHiNyugwCMT2qkKje0Gfod.pWzde_DOG 8wX7d60Z1IKPJk8H7MXCRbi4PWG61K5m7pWZpve1NEtXGQN0R0tVnpsyitEJJxof5ym5MmeR973T U.JXsd15M5ZL9GmCVOpiBd8E9B76h.CRZf_5iGrBeejfFSpmJNIk75j4NSc5N5hS4tAkNL884.Oo F9C2F4gBgtGOxtT3GEuxIve.BXyGXKFokuwU1IwSZfdl5MzI.UYKq5ZBXVqn5O8MmuMEp3NX7lxy waXt1KgV2KJeZMlRjc7C_9K0J8S_Ux_tIGrIuXFunPtLaGoDTvdgOAd9zLEeuY1rwvi7RRUDUcLl ymSZqHQMrxFuEZHqZQJAVH_FxieKDt_jFJtDRcCIrv.j4Xn4nFZXwSZUPmgGoqw8SxcO0Yn_ANtD k57OmmyFrpScvtjCvNJ97G9FYbZpNwd7NnUlXaE6iks0DMoUK8Soh7kaBXc1aKTqQnLJm712X2.R XAi5pEaIZZP_0cnspJL9Nk7r5PngfJDJf6hsNVsgt_GzydjqM9laeKaF3B7HqHBas.OCWkAuZp6P hWbUckT1EjRbUsHOmZ1BN57LoQiNv_8D_CHBFL5O2ze0Xn4YjLAynvRdAShVVL3VvtSSymYVTxxQ - X-Sonic-MF: X-Sonic-ID: 73988266-8645-4e0e-9f43-2a9cfe5bebe2 Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.bf2.yahoo.com with HTTP; Sun, 11 Feb 2024 23:02:11 +0000 Received: by hermes--production-bf1-7d6dbd57c9-4mgsj (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 8c16d29235fa1486de09519f20373ffe; Sun, 11 Feb 2024 23:02:07 +0000 (UTC) Content-Type: multipart/alternative; boundary=Apple-Mail-34E2282A-A478-4686-BF16-014FFD4F7836 Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (1.0) Subject: Re: ER diagram tools? From: GERALD CHEVES In-Reply-To: <1575236384.222264.1707512139163@connect.xfinity.com> Date: Sun, 11 Feb 2024 18:01:56 -0500 Cc: pgsql-novice Message-Id: <76819B9F-AB74-4285-95D7-C0EE7F198553@verizon.net> References: <1575236384.222264.1707512139163@connect.xfinity.com> To: TIM CHILD X-Mailer: iPhone Mail (20H19) Content-Length: 13060 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-34E2282A-A478-4686-BF16-014FFD4F7836 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable M

On Feb 9, 2024, at 3:56 PM, TIM CHILD <tim.child@comcast.net> w= rote:

=EF= =BB=BF =20 =20 =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-Relatio= nship Diagrams (ERDs) for PostgreSQL, yo= u have several options. Let me share some tools that you might find useful:
=20
 
=20
    =20
  1. =20
    pgAdmin 4:
    =20
     
    =20
      =20
    • Description: 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.
      • =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.=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 m= odeling tool with ERD capabilities for PostgreSQL (as well as other database= s 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 diagr= am tool for visually designing conceptual, logical, and physical data models= 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 com= prehensive suite of modeling tools, including ERD capabilities for PostgreSQ= L.
      • =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 database= modeling tool that supports PostgreSQL. It allows you to create ERDs and co= llaborate 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 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.
      • =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 fit= s 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.org= 2bin= g.com3youtub= e.com4youtube.com5youtube= .com6dbmstools.com7dbdiagrams.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
=20
How about SQL Workbench for PostgreSQL?

phoenixnap.com/kb/postgresql-workbench

I=E2=80=99= ve also used Smartdraw and Lucidchart but there=E2=80=99s a subscription fee= .
= --Apple-Mail-34E2282A-A478-4686-BF16-014FFD4F7836--