From: | Philip Rhoades <phil(at)pricom(dot)com(dot)au> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Software that can automatically make sense of a DB's tables and ID names |
Date: | 2018-06-12 17:14:48 |
Message-ID: | c7d1d0a9a1d57371c796699c982ca2b1@pricom.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
People,
I haven't really been keeping up with what is happening in the PG world
- now I have an old Discourse DB that I want to extract some of the
categories and topics from to insert into the current setup. What I was
wondering is if anyone has developed software in recent years that can
look at the DB as a whole and automatically make sense of how all the
tables relate to each other - assuming a sensible naming convention has
been used for IDs etc - and allows one to browse the tables easily
without having to manually type lots of SQL statements.
Discourse now has a utility for exporting and importing to do this sort
of stuff but I don't have a running setup for the old data - just a data
dump . .
Thanks,
Phil.
--
Philip Rhoades
PO Box 896
Cowra NSW 2794
Australia
E-mail: phil(at)pricom(dot)com(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-06-12 17:18:31 | Re: Software that can automatically make sense of a DB's tables and ID names |
Previous Message | Adrian Klaver | 2018-06-12 17:10:28 | Re: PG on AWS RDS and IAM authentication |