Friday, April 24, 2020

Database schema from postgres

Use pgModeler to connect postgres.

Then Import > Connection [choose local db loclhost 5432] > Database [pick one]

You see all tables.


Then click "Export".



Export as svg format.
When you have a lot of tables, you can't see this svg in whole.
Let's embed into html
<html> <html> <head> <title>Schema</title> </head> <body> <img src="./schema.svg" style="height:1000px;width:1900px"> </body> </html>
Then, open this html file to browser.




You can scroll up/down and left/right to see all tables.


No comments: