I found a way to see the database links, which show which tables are connected and their relationships using some Open Source software called Schemaspy. http://schemaspy.org/ It saves the database state in a folder of html files which you can view in your browser.
How to use: 1. Download the latest Schemaspy jar from https://github.com/schemaspy/schemaspy/releases/ 2. Download the PostgreSQL JDBC driver for Java 8 (assuming you're running openJDK 8) from https://jdbc.postgresql.org/download.html 3. Put both jars in a directory of your choosing and go to that directory. 4. Run the following command, changing details as necessary. (The list of commandline arguments for schemaspy is here: https://schemaspy.readthedocs.io/en/latest/configuration/commandline.html) This command uses schemaspy to map a psql db called mahara-master and output results to a new directory called schemaspy. (This took around 7 mins). java -jar schemaspy-6.1.0.jar -t pgsql -db mahara-master -host localhost -u maharauser -p maharapassword -o ./schemaspy -dp postgresql-42.2.9.jar -vizjs -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1855630 Title: Mahara map: an index of components Status in Mahara: New Bug description: Creating a map/library/index of Mahara components to know what things mean, what they connect to and how to find them. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1855630/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
