Is there a way to automatically generate table definitions on a mac?

Asked 2 years ago, Updated 2 years ago, 309 views

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.

pgAdmin outputting PostgreSQL table definitions may be achieved by the "reporting" feature, but when I tried the latest version of pgadmin version 4, I couldn't find the report output menu.This article is 10 years ago and relatively old information, so maybe the latest pgadmin won't do it?

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.

macos database-design

2022-10-12 01:01

1 Answers

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.


2022-10-12 01:01

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.