Generate relationships in pgAdmin 4 (Postgresql)?

Navigation
0

I am maintaining a database in Postgresql , being sincere it is very complex and I can not understand it completely. I have searched for information to be able to generate relationships between the tables, and thus better understand the database. What I have achieved is that a query will generate an "Explain" , which when executing my query I get a message box where the table information appears, but it does not finish helping me. Is there any way to make relationships better?

    
asked by José T. 13.12.2017 в 22:05
source

1 answer

1

The GUI of Navicat is an excellent choice because as you add tables in the constructor of query chart makes the relationships automatically (as long as the foreign keys exist):

The other option is to make a DUMP of your database, but only taking the scheme: 

pg_dump -U pgadmin my_base --schema-only

Already in the result of the DUMP you can check all the foreign keys and references to the tables and fields of your base.

    
answered by 07.01.2018 / 05:04
source
Dialing phone number from Android Studio Allow operator entry by the user