Hi Jack, On Thu, Dec 17, 2020 at 1:56 AM Jack Royal-Gordon <jac...@pobox.com> wrote:
> I have one question: is there any risk that this tool, when used with an > existing database, can affect the database at all (assuming you don’t > execute any of the DDL generated by it)? In other words, is it safe to use > with existing databases without risking any damage or changes to the > performance of the database? > The tool does not affect or execute any DDL on the existing DB. It generates a diagram for you. You can then use the SQL button to generate the CREATE DDL for the diagram, but it will not execute automatically. > > On Dec 16, 2020, at 3:29 AM, Akshay Joshi <akshay.jo...@enterprisedb.com> > wrote: > > Hi All > > pgAdmin team has pleased to announce that we have implemented the new > feature *ERDTool (Alpha).* It is not released yet as it is in the *alpha* > phase, > so we are providing the installers for trial purposes. > Installers can be found at > https://developer.pgadmin.org/builds/2020-12-16-1/ > > We highly appreciate it if a larger audience test this new ERDTool and > provide their *feedback*(positive/negative) > > *How to use:* > > 1) You can start a new ERD project from Tools -> New ERD Project. This > will open a blank canvas. Use the add button to create tables. Use - "1M" > for one to many links. Explore other options as well. > > <image.png>. <image.png> > > > 2) Alternatively, you can also generate the ER diagram for an existing > database. This will pull all the tables, link them, and arrange them. You > can also auto arrange it from the toolbar button. > > <image.png>. <image.png> > > > 3) You can save the project. The extension used here by the tool is > .pgerd. You can load this project anytime later. > > <image.png> > > > 4) Once you're happy, you can click on the "Generate SQL" to get the DDL. > This will open a new query tool with DDL. > <Screenshot 2020-12-10 at 2.29.17 PM.png>. <image.png> > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres <http://edbpostgres.com/>* > > *Mobile: +91 976-788-8246* > > > -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* <http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
