Re: Software that can automatically make sense of a DB's tables andID names - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Software that can automatically make sense of a DB's tables andID names
Date
Msg-id a20b531d-74f5-a8fd-c8d2-dbe4c4f37b75@aklaver.com
Whole thread Raw
In response to Software that can automatically make sense of a DB's tables and IDnames  (Philip Rhoades <phil@pricom.com.au>)
List pgsql-general
On 06/12/2018 10:14 AM, Philip Rhoades wrote:
> 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.

There are but the paragraph below seems to indicate you want something else.

> 
> 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 . .

So you want a tool to look at a data dump and build SQL?
> 
> Thanks,
> 
> Phil.


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Philip Rhoades
Date:
Subject: Software that can automatically make sense of a DB's tables and IDnames
Next
From: Andres Freund
Date:
Subject: Re: Print pg_lsn as a number?