Re: Converting Access .mdb to postgres

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Converting Access .mdb to postgres
Date: 2019-08-14 23:01:53
Message-ID: alpine.LNX.2.20.1908141539370.30697@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 14 Aug 2019, Rich Shepard wrote:

> Thanks, Adrian. This looks like it has all the information I need.

Adrian,

Off the mail list.

I'm reading that metadata document and it seems to me that it's not well
constructed. Perhaps this is an Access thing[1]; perhaps the DBA's have
limited knowledge. For example there are a lot of entity1_X_entity2 tables
which I think don't need to exist as one can get the same information from a
query. And, there are a bunch of lookup tables I think could be better
handled the postgres way.

Would you help me with this migration off the mail list?

Regards,

Rich

[1] I tried searching the database tables on their web site but could not
find the information I need. As far as I know Access is a flat-file
database, not relational.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-08-14 23:04:14 Re: Converting Access .mdb to postgres
Previous Message Rich Shepard 2019-08-14 19:28:38 Re: Converting Access .mdb to postgres