Until now, when creating table definitions, after modifying, adding, and deleting tables in the database, Windows automatically generated them using the A5 SQL feature (↓)
DB client:A5 SQL automatic table definition generation
*Please understand that what we call table definition in this question is a document similar to the one shown in the link above.
Due to work conditions, the development environment will be unified from Windows to Mac, requiring a means of outputting table definitions in addition to A5 SQL, which is only available on Windows.
I have been using automatic generation for a long time, but I would like to avoid increasing the cost of the work by returning to manual writing, but I am having trouble finding a good way to use the Mac.If you know the proper procedure, please let me know.
Managed DBMS are postgreSQL and MySQL.
As a tool for doing the same thing as A5 SQL on a Mac, it seems that there is no function to output table definitions.
I also thought of using psql's command (\d) to output table definitions, but I gave up the idea that the design like FOREGN KEY(hoge_id)REFERENCES...
is easy for us as developers to read and understand, but it's hard for us to read and understand.
I am the author of the article.
We have verified that the report output can be done with pgAdmin3.PostgreSQL:Up and Running states that "pgAdmin4 is a complete rewrite of pgAdmin3, some features are not ported to pgAdmin4", and the report output may not have been ported.
As an alternative, there is a way to output metadata from the table in SQL.
Table Definition Retrieval Query - Architect's Log
Our article targets SQL Server, but I think PostgreSQL and MySQL can do the same.
Also, I haven't checked if it supports Macs, but there seems to be a tool to output table definitions if it's okay to pay for them.
5 Different Types of Tools You Can Use to Create a Data Dictionary-Dataedo Blog
After I answered, I thought about setting up a Windows server for table definition output separately from the development environment.
In addition, cloud-based virtual servers can be stopped when they are not in use, thereby reducing usage fees.
917 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
578 Understanding How to Configure Google API Key
573 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
582 PHP ssh2_scp_send fails to send files as intended
574 Who developed the "avformat-59.dll" that comes with FFmpeg?
© 2024 OneMinuteCode. All rights reserved.